APPS.PQP_PENSION_FUNCTIONS dependencies on PAY_PAYROLLS_F

Line 2163: FROM pay_payrolls_f ppaf

2159: -- Cursor to get the number of pay periods per year.
2160: -- =======================================================================
2161: CURSOR c_pp_cur IS
2162: SELECT pety.number_per_fiscal_year
2163: FROM pay_payrolls_f ppaf
2164: ,per_time_period_types pety
2165: WHERE ppaf.payroll_id = p_payroll_id
2166: AND ppaf.period_type = pety.period_type;
2167:

Line 3149: l_payroll_id pay_payrolls_f.payroll_id%type;

3145: l_begin_of_year_date date;
3146: l_effective_date date;
3147: l_error_message varchar2(100);
3148: l_defined_bal_id number;
3149: l_payroll_id pay_payrolls_f.payroll_id%type;
3150: l_ass_act_id pay_assignment_actions.assignment_action_id%type := -1;
3151: l_cur_payroll_id pay_payrolls_f.payroll_id%type;
3152: l_period_start_dt per_time_periods.start_date%type;
3153: l_period_end_dt per_time_periods.end_date%type;

Line 3151: l_cur_payroll_id pay_payrolls_f.payroll_id%type;

3147: l_error_message varchar2(100);
3148: l_defined_bal_id number;
3149: l_payroll_id pay_payrolls_f.payroll_id%type;
3150: l_ass_act_id pay_assignment_actions.assignment_action_id%type := -1;
3151: l_cur_payroll_id pay_payrolls_f.payroll_id%type;
3152: l_period_start_dt per_time_periods.start_date%type;
3153: l_period_end_dt per_time_periods.end_date%type;
3154: l_time_period_id number;
3155: l_is_abp_pt number := 0;

Line 4545: l_payroll_id pay_payrolls_f.payroll_id%type;

4541: l_recur_bonus_period pqp_pension_types_f.recurring_bonus_period%type;
4542: l_non_recur_bonus_period pqp_pension_types_f.non_recurring_bonus_period%type;
4543: l_end_of_prev_yr date;
4544: l_prev_run_year number;
4545: l_payroll_id pay_payrolls_f.payroll_id%type;
4546: l_asg_action_id pay_assignment_actions.assignment_action_id%type;
4547: l_time_period_id per_time_periods.time_period_id%type;
4548: l_defined_bal_id pay_defined_balances.defined_balance_id%type;
4549: l_start_date per_time_periods.start_date%type;