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_QPU_API dependencies on PAY_ASSIGNMENT_ACTIONS

Line 71: , pay_assignment_actions aga

67: --
68: cursor csr_pay_act is
69: select 'Y'
70: from pay_payroll_actions pya
71: , pay_assignment_actions aga
72: where pya.payroll_action_id = p_target_payroll_action_id
73: and pya.action_type = 'Q'
74: and aga.payroll_action_id = pya.payroll_action_id
75: and aga.action_status in ('C', 'S');

Line 87: , pay_assignment_actions app

83: cursor csr_no_lck is
84: select /*+ INDEX(ppq PAY_PAYROLL_ACTIONS_PK) */
85: 'Y'
86: from pay_payroll_actions ppq
87: , pay_assignment_actions app
88: , pay_action_interlocks ail
89: , pay_assignment_actions aqr
90: where aqr.payroll_action_id = p_target_payroll_action_id
91: and ail.locked_action_id = aqr.assignment_action_id

Line 89: , pay_assignment_actions aqr

85: 'Y'
86: from pay_payroll_actions ppq
87: , pay_assignment_actions app
88: , pay_action_interlocks ail
89: , pay_assignment_actions aqr
90: where aqr.payroll_action_id = p_target_payroll_action_id
91: and ail.locked_action_id = aqr.assignment_action_id
92: and app.assignment_action_id = ail.locking_action_id
93: and ppq.payroll_action_id = app.payroll_action_id

Line 427: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE

423: -- |----------------------------< paid_payments >-----------------------------|
424: -- ----------------------------------------------------------------------------
425: --
426: function paid_payments
427: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
428: ) return boolean is
429: --
430: l_exists varchar2(1);
431: l_paid boolean;

Line 437: , pay_assignment_actions aac

433: --
434: cursor csr_paid is
435: select 'Y'
436: from pay_payroll_actions pac
437: , pay_assignment_actions aac
438: , pay_action_interlocks aci
439: where aci.locked_action_id = p_assignment_action_id
440: and aac.assignment_action_id = aci.locking_action_id
441: and pac.payroll_action_id = aac.payroll_action_id

Line 1190: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

1186: --
1187: -- These variables are set by inserting the assignment action.
1188: -- The values are returned from this procedure.
1189: --
1190: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1191: l_object_version_number pay_assignment_actions.object_version_number%TYPE;
1192: --
1193: Begin
1194: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1191: l_object_version_number pay_assignment_actions.object_version_number%TYPE;

1187: -- These variables are set by inserting the assignment action.
1188: -- The values are returned from this procedure.
1189: --
1190: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1191: l_object_version_number pay_assignment_actions.object_version_number%TYPE;
1192: --
1193: Begin
1194: hr_utility.set_location('Entering:'||l_proc, 5);
1195: --

Line 1308: , pay_assignment_actions aga

1304: , pya.target_payroll_action_id
1305: , aga.object_version_number
1306: , pya.object_version_number
1307: from pay_payroll_actions pya
1308: , pay_assignment_actions aga
1309: where /* Payroll action lock */
1310: pya.payroll_action_id = p_payroll_action_id
1311: and pya.action_type = 'U'
1312: /* Assignment action lock */

Line 1723: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

1719: l_action_population_status pay_payroll_actions.action_population_status%TYPE;
1720: --
1721: -- These variables are set by post_insert and returned from this procedure
1722: --
1723: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1724: l_a_object_version_number pay_assignment_actions.object_version_number%TYPE;
1725: --
1726: Begin
1727: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1724: l_a_object_version_number pay_assignment_actions.object_version_number%TYPE;

1720: --
1721: -- These variables are set by post_insert and returned from this procedure
1722: --
1723: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1724: l_a_object_version_number pay_assignment_actions.object_version_number%TYPE;
1725: --
1726: Begin
1727: hr_utility.set_location('Entering:'||l_proc, 5);
1728: --

Line 2072: ,p_action_status out nocopy pay_assignment_actions.action_status%TYPE

2068: -- ----------------------------------------------------------------------------
2069: --
2070: procedure get_latest_status
2071: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
2072: ,p_action_status out nocopy pay_assignment_actions.action_status%TYPE
2073: ) is
2074: l_proc varchar2(72) := g_package||'get_latest_status';
2075: l_argument varchar2(30);
2076: --

Line 2080: , pay_assignment_actions aga

2076: --
2077: cursor cur_stat is
2078: select aga.action_status
2079: from pay_payroll_actions pya
2080: , pay_assignment_actions aga
2081: where pya.payroll_action_id = p_payroll_action_id
2082: and aga.payroll_action_id = pya.payroll_action_id;
2083: begin
2084: hr_utility.set_location('Entering:'|| l_proc, 5);