APPS.PER_MX_SSAFFL_DISPMAG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 285: pay_assignment_actions paa,

281: and ((org_information6 = cp_trans_gre_id ) OR ( organization_id = cp_trans_gre_id and org_information3='Y')))))
282: and not exists (
283: select 'Y'
284: from pay_action_interlocks pal,
285: pay_assignment_actions paa,
286: pay_payroll_actions ppa
287: where pal.locked_action_id = pai.action_context_id
288: and pal.locking_action_id = paa.assignment_action_id
289: and paa.payroll_action_id = ppa.payroll_action_id

Line 357: select pay_assignment_actions_s.nextval

353: exit when c_get_asg%notfound;
354:
355: -- create assignment action
356:
357: select pay_assignment_actions_s.nextval
358: into ln_action_id
359: from dual;
360:
361:

Line 362: -- insert into pay_assignment_actions.

358: into ln_action_id
359: from dual;
360:
361:
362: -- insert into pay_assignment_actions.
363: hr_nonrun_asact.insact(ln_action_id,
364: ln_assignment_id,
365: p_payroll_action_id,
366: p_chunk,

Line 553: pay_assignment_actions paa

549: format_data_string(rpad(action_information20,18,' '))||
550: format_data_string(action_information21)
551: from pay_action_information pai,
552: pay_action_interlocks pal,
553: pay_assignment_actions paa
554: where pal.locking_action_id = cp_assignment_action_id
555: and pal.locked_action_id = pai.action_context_id
556: and pai.action_context_type ='AAP'
557: and pai.action_information_category = 'MX SS HIRE DETAILS'

Line 613: pay_assignment_actions paa

609: format_data_string(rpad(' ',18,' ')) ||
610: format_data_string(action_information16)
611: from pay_action_information pai,
612: pay_action_interlocks pal,
613: pay_assignment_actions paa
614: where pal.locking_action_id = cp_assignment_action_id
615: and pal.locked_action_id = pai.action_context_id
616: and pai.action_context_type ='AAP'
617: and pai.action_information_category = 'MX SS SEPARATION DETAILS'