APPS.PER_MX_SSAFFL_DISPMAG dependencies on PAY_ACTION_INTERLOCKS

Line 284: from pay_action_interlocks pal,

280: where hoi.org_information_context = 'MX_SOC_SEC_DETAILS'
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

Line 552: pay_action_interlocks pal,

548: format_data_string(' ') ||
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'

Line 612: pay_action_interlocks pal,

608: format_data_string(nvl(action_information14,' ')) ||
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'