APPS.PQP_US_PENSION_EXTRACTS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 137: FROM pay_assignment_actions paa

133: SELECT paa.assignment_action_id
134: ,ppa.effective_date
135: ,ppa.action_type
136: ,paa.tax_unit_id
137: FROM pay_assignment_actions paa
138: ,pay_payroll_actions ppa
139: ,pay_action_classifications pac
140: WHERE paa.assignment_id = c_assignment_id
141: AND paa.tax_unit_id = nvl(c_gre_id,paa.tax_unit_id)

Line 4331: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

4327: l_result_value pay_run_result_values.result_value%TYPE;
4328: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
4329: l_effective_date DATE;
4330: l_return_value VARCHAR2(50) := '0';
4331: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
4332: l_error_message VARCHAR2(3000);
4333: l_legislation_code per_business_groups.legislation_code%TYPE;
4334: l_index NUMBER :=0;
4335: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Element_Entry_Value';

Line 4430: l_assignment_action_id pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE;

4426: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
4427: l_balance_dimension_id pay_balance_dimensions.balance_dimension_id%TYPE;
4428: l_new_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
4429: l_index NUMBER;
4430: l_assignment_action_id pay_assignment_actions.ASSIGNMENT_ACTION_ID%TYPE;
4431: l_yr_end_date DATE;
4432: l_yr_start_date DATE;
4433: l_beg_amt NUMBER :=0;
4434: l_bal_amt NUMBER :=0;

Line 4449: FROM pay_assignment_actions paa,

4445: ,c_start_date IN DATE
4446: ,c_end_date IN DATE
4447: ) IS
4448: SELECT paa.assignment_action_id
4449: FROM pay_assignment_actions paa,
4450: pay_payroll_actions ppa,
4451: pay_action_classifications pac
4452: WHERE paa.assignment_id = c_assignment_id
4453: AND paa.tax_unit_id = nvl(c_gre_id,paa.tax_unit_id)