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.PAY_CA_RL2_CAN_MAG dependencies on PAY_ACTION_INTERLOCKS

Line 308: pay_action_interlocks int

304: pay_payroll_actions ppa1,
305: pay_payroll_actions ppa2,
306: pay_assignment_actions paa,
307: pay_assignment_actions paa1,
308: pay_action_interlocks int
309: where
310: ppa.payroll_action_id = paa.payroll_action_id
311: and paa.assignment_id = paaf.assignment_id
312: and ppa1.payroll_action_id = p_pactid

Line 323: from pay_action_interlocks pai, pay_assignment_actions paa2

319: and ppa2.payroll_action_id = paa1.payroll_action_id
320: and ppa2.action_status = 'C'
321: and paa.assignment_action_id
322: not in (select paa2.assignment_action_id
323: from pay_action_interlocks pai, pay_assignment_actions paa2
324: where paa2.assignment_action_id = pai.locked_action_id
325: and paa2.payroll_action_id =
326: to_number(pay_ca_rl2_can_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
327: )

Line 348: pay_action_interlocks int

344: pay_payroll_actions ppa1,
345: pay_payroll_actions ppa2,
346: pay_assignment_actions paa,
347: pay_assignment_actions paa1,
348: pay_action_interlocks int
349: where
350: ppa.payroll_action_id = paa.payroll_action_id
351: and paa.assignment_id = paaf.assignment_id
352: and ppa1.payroll_action_id = p_pactid

Line 370: from pay_action_interlocks pai, pay_assignment_actions paa2

366: and hasa.assignment_id = paf.assignment_id
367: and paf.person_id = paaf.person_id)
368: and paa.assignment_action_id
369: not in (select paa2.assignment_action_id
370: from pay_action_interlocks pai, pay_assignment_actions paa2
371: where paa2.assignment_action_id = pai.locked_action_id
372: and paa2.payroll_action_id =
373: to_number(pay_ca_rl2_can_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
374: )

Line 944: pay_action_interlocks int

940: select max(paa1.payroll_action_id)
941: into l_payroll_actid
942: from pay_assignment_actions paa,
943: pay_assignment_actions paa1,
944: pay_action_interlocks int
945: where int.locking_action_id = paa.assignment_action_id
946: AND paa1.assignment_action_id = int.locked_action_id
947: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
948:

Line 1382: pay_action_interlocks pai_mag,

1378: pay_ca_rl2_can_mag.get_parameter('PRE_ORGANIZATION_ID',ppa_arch.legislative_parameters)
1379: FROM
1380: per_all_people_f ppf,
1381: per_all_assignments_f paf,
1382: pay_action_interlocks pai_mag,
1383: pay_action_interlocks pai_arch,
1384: pay_payroll_actions ppa,
1385: pay_payroll_actions ppa_arch,
1386: pay_assignment_actions paa_mag,

Line 1383: pay_action_interlocks pai_arch,

1379: FROM
1380: per_all_people_f ppf,
1381: per_all_assignments_f paf,
1382: pay_action_interlocks pai_mag,
1383: pay_action_interlocks pai_arch,
1384: pay_payroll_actions ppa,
1385: pay_payroll_actions ppa_arch,
1386: pay_assignment_actions paa_mag,
1387: pay_assignment_actions paa_arch,

Line 2748: pay_action_interlocks int

2744: select max(paa1.payroll_action_id)
2745: into l_payroll_actid
2746: from pay_assignment_actions paa,
2747: pay_assignment_actions paa1,
2748: pay_action_interlocks int
2749: where int.locking_action_id = paa.assignment_action_id
2750: AND paa1.assignment_action_id = int.locked_action_id
2751: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
2752: