APPS.PAY_MX_SSAFFL_SALARY dependencies on PAY_ASSIGNMENT_ACTIONS

Line 131: from pay_assignment_actions paa,

127: 'TRANS_GRE=') - 1 )
128: - (instr(ppa.legislative_parameters,
129: 'END_DATE=')
130: + length('END_DATE='))))))
131: from pay_assignment_actions paa,
132: pay_payroll_actions ppa
133: where paa.tax_unit_id = cp_tax_unit_id
134: and ppa.payroll_action_id=paa.payroll_action_id
135: and ppa.report_type='SS_AFFILIATION'

Line 861: select pay_assignment_actions_s.nextval

857: ln_step := 4;
858: dbg('creating aaid for assignment_id = ' || to_char(ln_assignment_id) ||
859: ' Tax Unit Id = ' || to_char(nvl(ln_gre_id,ln_tran_gre_id)) ) ;
860:
861: select pay_assignment_actions_s.nextval
862: into ln_action_id
863: from dual;
864:
865: -- insert into pay_assignment_actions.

Line 865: -- insert into pay_assignment_actions.

861: select pay_assignment_actions_s.nextval
862: into ln_action_id
863: from dual;
864:
865: -- insert into pay_assignment_actions.
866: hr_nonrun_asact.insact(ln_action_id,
867: ln_assignment_id,
868: p_payroll_action_id,
869: p_chunk,

Line 1307: from pay_assignment_actions paa

1303: cursor c_asg_action_info (cp_assignment_action in number) is
1304: select paa.payroll_action_id,
1305: paa.assignment_id,
1306: paa.tax_unit_id
1307: from pay_assignment_actions paa
1308: where paa.assignment_action_id = cp_assignment_action;
1309:
1310:
1311: cursor c_get_fix_sal_date( cp_assignment_id in number