APPS.PAY_CA_T4A_MAG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 130: pay_assignment_actions paa,

126: /* Changed to fix performance bug */
127: p_sqlstr := 'select distinct to_number(fai1.value)
128: from ff_archive_items fai1,
129: ff_archive_items fai2,
130: pay_assignment_actions paa,
131: pay_payroll_actions ppa,
132: pay_payroll_actions ppa1
133: where ppa1.payroll_action_id = :p_pactid
134: and ppa.report_type = ''T4A''

Line 198: pay_assignment_actions paa,

194: Paa.tax_unit_id,
195: paf.effective_end_date,
196: paa.assignment_action_id
197: FROM pay_payroll_actions ppa,
198: pay_assignment_actions paa,
199: per_all_assignments_f paf,
200: pay_payroll_actions ppa1,
201: hr_organization_information hoi1
202: WHERE ppa1.payroll_action_id = p_pactid

Line 290: SELECT pay_assignment_actions_s.nextval

286:
287: hr_utility.set_location(
288: 'pay_ca_t4a_mag.create_assignement_act', 40);
289:
290: SELECT pay_assignment_actions_s.nextval
291: INTO lockingactid
292: FROM dual;
293: hr_utility.set_location(
294: 'pay_ca_t4a_mag.create_assignement_act', 50);

Line 497: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;

493: l_trans_bus_no VARCHAR2(240);
494: l_bus_no VARCHAR2(240) ;
495: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
496: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
497: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
498: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
499: l_acc_info_flag CHAR(1);
500: l_trans_name VARCHAR2(240);
501: l_gre_name VARCHAR2(240);

Line 498: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

494: l_bus_no VARCHAR2(240) ;
495: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
496: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
497: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
498: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
499: l_acc_info_flag CHAR(1);
500: l_trans_name VARCHAR2(240);
501: l_gre_name VARCHAR2(240);
502: l_bg_id NUMBER;