APPS.PQP_PENSION_EXTRACTS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 96: FROM pay_assignment_actions paa

92: SELECT paa.assignment_action_id
93: ,ppa.effective_date
94: ,ppa.action_type
95: ,paa.tax_unit_id
96: FROM pay_assignment_actions paa
97: ,pay_payroll_actions ppa
98: WHERE paa.assignment_id = c_assignment_id
99: AND ppa.action_status = 'C'
100: AND paa.action_status = 'C'

Line 121: FROM pay_assignment_actions paa,

117: SELECT paa.assignment_action_id
118: ,ppa.effective_date
119: ,ppa.action_type
120: ,paa.tax_unit_id
121: FROM pay_assignment_actions paa,
122: pay_payroll_actions ppa,
123: pay_action_classifications pac
124: WHERE paa.assignment_id = c_assignment_id
125: AND (c_gre_id is null or

Line 169: FROM pay_assignment_actions paa,

165: SELECT paa.assignment_action_id
166: ,ppa.effective_date
167: ,ppa.action_type
168: ,paa.tax_unit_id
169: FROM pay_assignment_actions paa,
170: pay_payroll_actions ppa,
171: pay_action_classifications pac
172: WHERE paa.assignment_id = c_assignment_id
173: AND (c_gre_id is null or

Line 3385: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

3381: l_result_value pay_run_result_values.result_value%TYPE;
3382: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
3383: l_effective_date DATE;
3384: l_return_value VARCHAR2(50) := '0';
3385: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
3386: l_error_message VARCHAR2(3000);
3387: l_legislation_code per_business_groups.legislation_code%TYPE;
3388: l_index NUMBER :=0;
3389: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Entry_Value';