APPS.PER_MX_SSAFFL_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 218: from pay_assignment_actions paa,

214: 'LEGAL_EMPLOYER=') - 1 )
215: - (instr(ppa.legislative_parameters,
216: 'END_DATE=')
217: + length('END_DATE='))))))
218: from pay_assignment_actions paa,
219: pay_payroll_actions ppa
220: where paa.tax_unit_id = cp_tax_unit_id
221: and ppa.payroll_action_id=paa.payroll_action_id
222: and ppa.report_type='SS_AFFILIATION'

Line 738: select pay_assignment_actions_s.nextval

734: ln_step := 4;
735: dbg('creating aaid for assignment_id = ' || to_char(ln_assignment_id) ||
736: ' Tax Unit Id = ' || to_char(nvl(ln_gre_id,ln_tran_gre_id)) ) ;
737:
738: select pay_assignment_actions_s.nextval
739: into ln_action_id
740: from dual;
741:
742:

Line 743: -- insert into pay_assignment_actions.

739: into ln_action_id
740: from dual;
741:
742:
743: -- insert into pay_assignment_actions.
744: hr_nonrun_asact.insact(ln_action_id,
745: ln_assignment_id,
746: p_payroll_action_id,
747: p_chunk,

Line 3150: from pay_assignment_actions paa

3146: cursor c_asg_action_info (cp_assignment_action in number) is
3147: select paa.payroll_action_id,
3148: paa.assignment_id,
3149: paa.tax_unit_id
3150: from pay_assignment_actions paa
3151: where paa.assignment_action_id = cp_assignment_action;
3152:
3153:
3154: lv_procedure_name VARCHAR2(100);