APPS.PQP_PENSION_FUNCTIONS dependencies on PAY_PAYROLLS_F

Line 2098: FROM pay_payrolls_f ppaf

2094: -- Cursor to get the number of pay periods per year.
2095: -- =======================================================================
2096: CURSOR c_pp_cur IS
2097: SELECT pety.number_per_fiscal_year
2098: FROM pay_payrolls_f ppaf
2099: ,per_time_period_types pety
2100: WHERE ppaf.payroll_id = p_payroll_id
2101: AND ppaf.period_type = pety.period_type;
2102:

Line 3052: l_payroll_id pay_payrolls_f.payroll_id%type;

3048: l_begin_of_year_date date;
3049: l_effective_date date;
3050: l_error_message varchar2(100);
3051: l_defined_bal_id number;
3052: l_payroll_id pay_payrolls_f.payroll_id%type;
3053: l_ass_act_id pay_assignment_actions.assignment_action_id%type := -1;
3054: l_cur_payroll_id pay_payrolls_f.payroll_id%type;
3055: l_period_start_dt per_time_periods.start_date%type;
3056: l_period_end_dt per_time_periods.end_date%type;

Line 3054: l_cur_payroll_id pay_payrolls_f.payroll_id%type;

3050: l_error_message varchar2(100);
3051: l_defined_bal_id number;
3052: l_payroll_id pay_payrolls_f.payroll_id%type;
3053: l_ass_act_id pay_assignment_actions.assignment_action_id%type := -1;
3054: l_cur_payroll_id pay_payrolls_f.payroll_id%type;
3055: l_period_start_dt per_time_periods.start_date%type;
3056: l_period_end_dt per_time_periods.end_date%type;
3057: l_time_period_id number;
3058: l_is_abp_pt number := 0;

Line 4448: l_payroll_id pay_payrolls_f.payroll_id%type;

4444: l_recur_bonus_period pqp_pension_types_f.recurring_bonus_period%type;
4445: l_non_recur_bonus_period pqp_pension_types_f.non_recurring_bonus_period%type;
4446: l_end_of_prev_yr date;
4447: l_prev_run_year number;
4448: l_payroll_id pay_payrolls_f.payroll_id%type;
4449: l_asg_action_id pay_assignment_actions.assignment_action_id%type;
4450: l_time_period_id per_time_periods.time_period_id%type;
4451: l_defined_bal_id pay_defined_balances.defined_balance_id%type;
4452: l_start_date per_time_periods.start_date%type;