APPS.PAY_CA_T4_MAG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 98: pay_assignment_actions paa,

94: from ff_archive_items fai1,
95: ff_database_items fdi1,
96: ff_archive_items fai2,
97: ff_database_items fdi2,
98: pay_assignment_actions paa,
99: pay_payroll_actions ppa,
100: pay_payroll_actions ppa1
101: where ppa1.payroll_action_id = :payroll_action_id
102: and ppa.business_group_id+0 = ppa1.business_group_id

Line 157: pay_assignment_actions paa,

153: Paa.tax_unit_id,
154: paf.effective_end_date,
155: paa.assignment_action_id
156: FROM pay_payroll_actions ppa,
157: pay_assignment_actions paa,
158: per_all_assignments_f paf,
159: pay_payroll_actions ppa1
160: WHERE ppa1.payroll_action_id = p_pactid
161: AND ppa.report_type = 'T4'

Line 258: SELECT pay_assignment_actions_s.nextval

254:
255: hr_utility.set_location(
256: 'pay_ca_t4_mag.create_assignement_act', 40);
257:
258: SELECT pay_assignment_actions_s.nextval
259: INTO lockingactid
260: FROM dual;
261:
262: hr_utility.set_location(

Line 841: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;

837: l_bus_no VARCHAR2(240) ;
838: l_bg_id number ;
839: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
840: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
841: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
842: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
843: l_acc_info_flag CHAR(1);
844: l_gre_name VARCHAR2(240);
845:

Line 842: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

838: l_bg_id number ;
839: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
840: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
841: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
842: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
843: l_acc_info_flag CHAR(1);
844: l_gre_name VARCHAR2(240);
845:
846: BEGIN