APPS.PQP_PENSION_FUNCTIONS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1881: FROM pay_assignment_actions paa

1877: l_ass_act_id NUMBER;
1878:
1879: CURSOR c_ass_act IS
1880: SELECT max(paa.assignment_action_id)
1881: FROM pay_assignment_actions paa
1882: ,pay_payroll_actions ppa
1883: WHERE paa.assignment_id = p_assignment_id
1884: AND ppa.action_status = 'C'
1885: AND ppa.action_type IN ('Q','R')

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

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

Line 3111: ,pay_assignment_actions paa

3107: ,c_period_start IN DATE
3108: ,c_period_end IN DATE) IS
3109: SELECT paa.assignment_action_id
3110: FROM pay_payroll_actions ppa
3111: ,pay_assignment_actions paa
3112: where ppa.payroll_action_id = paa.payroll_action_id
3113: and ppa.time_period_id = c_time_period_id
3114: --and payroll_id = c_payroll_id
3115: and paa.assignment_id = p_assignment_id

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

Line 4506: ,pay_assignment_actions paa

4502: ,c_period_start IN DATE
4503: ,c_period_end IN DATE) IS
4504: SELECT paa.assignment_action_id
4505: FROM pay_payroll_actions ppa
4506: ,pay_assignment_actions paa
4507: WHERE ppa.payroll_action_id = paa.payroll_action_id
4508: AND ppa.time_period_id = c_time_period_id
4509: AND paa.assignment_id = p_assignment_id
4510: AND ppa.action_type in ('R','Q')

Line 4932: FROM pay_assignment_actions

4928:
4929: --
4930: CURSOR csr_get_pay_action_id(c_assignment_action_id NUMBER) IS
4931: SELECT payroll_action_id
4932: FROM pay_assignment_actions
4933: WHERE assignment_action_id = c_assignment_action_id;
4934: --
4935: l_payroll_action_id number;
4936: l_part_time_perc varchar2(35);

Line 5016: FROM pay_assignment_actions

5012:
5013: --
5014: CURSOR csr_get_pay_action_id(c_assignment_action_id NUMBER) IS
5015: SELECT payroll_action_id
5016: FROM pay_assignment_actions
5017: WHERE assignment_action_id = c_assignment_action_id;
5018: --
5019: l_payroll_action_id number;
5020: l_part_time_perc varchar2(35);