APPS.PQP_PENSION_FUNCTIONS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1946: FROM pay_assignment_actions paa

1942: l_ass_act_id NUMBER;
1943:
1944: CURSOR c_ass_act IS
1945: SELECT max(paa.assignment_action_id)
1946: FROM pay_assignment_actions paa
1947: ,pay_payroll_actions ppa
1948: WHERE paa.assignment_id = p_assignment_id
1949: AND ppa.action_status = 'C'
1950: AND ppa.action_type IN ('Q','R')

Line 3150: l_ass_act_id pay_assignment_actions.assignment_action_id%type := -1;

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;
3154: l_time_period_id number;

Line 3208: ,pay_assignment_actions paa

3204: ,c_period_start IN DATE
3205: ,c_period_end IN DATE) IS
3206: SELECT paa.assignment_action_id
3207: FROM pay_payroll_actions ppa
3208: ,pay_assignment_actions paa
3209: where ppa.payroll_action_id = paa.payroll_action_id
3210: and ppa.time_period_id = c_time_period_id
3211: --and payroll_id = c_payroll_id
3212: and paa.assignment_id = p_assignment_id

Line 4546: l_asg_action_id pay_assignment_actions.assignment_action_id%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;
4550: l_end_date per_time_periods.end_date%type;

Line 4603: ,pay_assignment_actions paa

4599: ,c_period_start IN DATE
4600: ,c_period_end IN DATE) IS
4601: SELECT paa.assignment_action_id
4602: FROM pay_payroll_actions ppa
4603: ,pay_assignment_actions paa
4604: WHERE ppa.payroll_action_id = paa.payroll_action_id
4605: AND ppa.time_period_id = c_time_period_id
4606: AND paa.assignment_id = p_assignment_id
4607: AND ppa.action_type in ('R','Q')

Line 5029: FROM pay_assignment_actions

5025:
5026: --
5027: CURSOR csr_get_pay_action_id(c_assignment_action_id NUMBER) IS
5028: SELECT payroll_action_id
5029: FROM pay_assignment_actions
5030: WHERE assignment_action_id = c_assignment_action_id;
5031: --
5032: l_payroll_action_id number;
5033: l_part_time_perc varchar2(35);

Line 5113: FROM pay_assignment_actions

5109:
5110: --
5111: CURSOR csr_get_pay_action_id(c_assignment_action_id NUMBER) IS
5112: SELECT payroll_action_id
5113: FROM pay_assignment_actions
5114: WHERE assignment_action_id = c_assignment_action_id;
5115: --
5116: l_payroll_action_id number;
5117: l_part_time_perc varchar2(35);