eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_MX_SS_AFFILIATION dependencies on PAY_ACTION_INTERLOCKS

Line 428: pay_action_interlocks lck

424: AND fnd_date.canonical_to_date (g_end_date)
425: /*NOT EXISTS (SELECT 'X'
426: FROM pay_payroll_actions ppa_affl,
427: pay_assignment_actions paa_affl,
428: pay_action_interlocks lck
429: WHERE lck.locked_action_id = pai.action_context_id
430: AND lck.locking_action_id = paa_affl.assignment_action_id
431: AND paa_affl.payroll_action_id = ppa_affl.payroll_action_id
432: AND ppa_affl.report_type = 'MX_SS_AFFL'

Line 480: pay_action_interlocks lck

476: AND fnd_date.canonical_to_date (g_end_date)
477: /*NOT EXISTS (SELECT 'X'
478: FROM pay_payroll_actions ppa_affl,
479: pay_assignment_actions paa_affl,
480: pay_action_interlocks lck
481: WHERE lck.locked_action_id = pai.action_context_id
482: AND lck.locking_action_id = paa_affl.assignment_action_id
483: AND paa_affl.payroll_action_id = ppa_affl.payroll_action_id
484: AND ppa_affl.report_type = 'MX_SS_AFFL'

Line 674: pay_action_interlocks lck,

670: SELECT fnd_number.canonical_to_number(pai.action_information8)
671: FROM pay_payroll_actions ppa_mag,
672: pay_assignment_actions paa_mag,
673: --pay_assignment_actions paa_arch,
674: pay_action_interlocks lck,
675: pay_action_information pai
676: WHERE ppa_mag.payroll_action_id = paa_mag.payroll_action_id
677: AND paa_mag.assignment_action_id = lck.locking_action_id
678: /*AND lck.locked_action_id = paa_arch.assignment_action_id

Line 835: pay_action_interlocks lck*/

831: pai.action_information18 -- Salary Type
832: -- Bug 6065124
833: FROM pay_action_information pai /*,
834: pay_assignment_actions paa_arch,
835: pay_action_interlocks lck*/
836: WHERE pai.action_information_category = 'MX SS PERSON INFORMATION'
837: /*and lck.locking_action_id = cp_assignment_action_id
838: AND lck.locked_action_id = pai.action_context_id*/
839: AND pai.action_context_type = 'AAP'

Line 860: pay_action_interlocks lck

856: ppa.legislative_parameters))
857: FROM pay_payroll_actions ppa,
858: pay_assignment_actions paa,
859: pay_action_information pai,
860: pay_action_interlocks lck
861: WHERE paa.payroll_action_id = ppa.payroll_action_id
862: AND paa.assignment_action_id = lck.locking_action_id
863: AND pai.action_context_id = lck.locked_action_id
864: AND pai.action_information_category = 'MX SS PERSON INFORMATION'

Line 926: pay_action_interlocks lck

922: pai.action_information5, -- Employer SS ID
923: fnd_number.canonical_to_number (pai.action_information8), -- IDW
924: pai.action_information9 -- Leaving reason
925: FROM pay_action_information pai,
926: pay_action_interlocks lck
927: WHERE lck.locking_action_id = cp_assignment_action_id
928: AND lck.locked_action_id = pai.action_context_id
929: AND pai.action_information_category = 'MX SS TRANSACTIONS'
930: AND pai.action_information4 IN ('02', '07', '08')

Line 948: pay_action_interlocks lck

944: AND fnd_date.canonical_to_date (g_end_date)
945: /*NOT EXISTS (SELECT 'X'
946: FROM pay_payroll_actions ppa_affl,
947: pay_assignment_actions paa_affl,
948: pay_action_interlocks lck
949: WHERE lck.locked_action_id = pai.action_context_id
950: AND lck.locking_action_id = paa_affl.assignment_action_id
951: AND paa_affl.payroll_action_id = ppa_affl.payroll_action_id
952: AND ppa_affl.report_type = 'MX_SS_AFFL'

Line 1204: pay_action_interlocks lck,

1200:
1201: CURSOR csr_employer IS
1202: SELECT pai.action_information_id
1203: FROM pay_action_information pai,
1204: pay_action_interlocks lck,
1205: pay_assignment_actions paa_affl,
1206: pay_assignment_actions paa_arch
1207: WHERE paa_affl.payroll_action_id =
1208: pay_magtape_generic.get_parameter_value ('PAYROLL_ACTION_ID')