DBA Data[Home] [Help]

APPS.PAY_JP_UITE_ARCH_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 939: FROM pay_action_interlocks PAI,

935: AND PPA.element_set_id = gn_sal_ele_set_id
936: AND PPA.action_type in ('R','Q','G','L')
937: AND NOT EXISTS(
938: SELECT null
939: FROM pay_action_interlocks PAI,
940: pay_assignment_actions PAAI,
941: pay_payroll_actions PPAI
942: WHERE PAI.locked_action_id = PAA.assignment_action_id
943: AND PAAI.assignment_action_id = PAI.locking_action_id

Line 976: FROM pay_action_interlocks PAI,

972: AND PPA.element_set_id = gn_sal_ele_set_id
973: AND PPA.action_type in ('R','Q','G','L')
974: AND NOT EXISTS(
975: SELECT null
976: FROM pay_action_interlocks PAI,
977: pay_assignment_actions PAAI,
978: pay_payroll_actions PPAI
979: WHERE PAI.locked_action_id = PAA.assignment_action_id
980: AND PAAI.assignment_action_id = PAI.locking_action_id

Line 1790: FROM pay_action_interlocks pai,

1786: AND ppa.element_set_id = gn_spb_ele_set_id
1787: AND ppa.action_type in ('R','Q','G','L')
1788: AND NOT EXISTS(
1789: SELECT null
1790: FROM pay_action_interlocks pai,
1791: pay_assignment_actions paa2,
1792: pay_payroll_actions ppa2
1793: WHERE pai.locked_action_id = paa.assignment_action_id
1794: AND paa2.assignment_action_id = pai.locking_action_id