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

Line 35: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

31: p_object_version_number out nocopy number
32: ) is
33:
34: l_assignment_id number;
35: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
36: l_locking_action_id number;
37: l_qpp_locked_action_id number;
38: l_qp_locked_action_id number;
39: l_locked_action_id number;

Line 45: pay_assignment_actions act

41:
42: cursor c_qpaction is
43: select act.assignment_action_id
44: from pay_payroll_actions pac,
45: pay_assignment_actions act
46: where pac.payroll_action_id = p_payroll_action_id
47: and act.payroll_action_id = pac.target_payroll_action_id
48: and act.source_action_id is null;
49:

Line 52: from pay_assignment_actions act,

48: and act.source_action_id is null;
49:
50: cursor c_asgid is
51: select act.assignment_id
52: from pay_assignment_actions act,
53: pay_payroll_actions pac
54: where pac.payroll_action_id = p_payroll_action_id
55: and act.payroll_action_id = pac.target_payroll_action_id
56: and act.source_action_id is null;

Line 60: from pay_assignment_actions pac

56: and act.source_action_id is null;
57:
58: cursor c_qppaction is
59: select pac.assignment_action_id,pac.tax_unit_id
60: from pay_assignment_actions pac
61: where pac.payroll_action_id = (select ppa.payroll_action_id
62: from pay_payroll_actions ppa
63: where ppa.target_payroll_action_id = (select ppa.target_payroll_action_id
64: from pay_payroll_actions ppa

Line 71: from pay_assignment_actions pac

67: and ppa.action_status = 'C');
68:
69: cursor c_qparcassact is
70: select pac.assignment_action_id
71: from pay_assignment_actions pac
72: where pac.payroll_action_id =p_payroll_action_id;
73:
74: cursor c_next_assact is
75: select pay_assignment_actions_s.nextval

Line 75: select pay_assignment_actions_s.nextval

71: from pay_assignment_actions pac
72: where pac.payroll_action_id =p_payroll_action_id;
73:
74: cursor c_next_assact is
75: select pay_assignment_actions_s.nextval
76: from sys.dual;
77:
78: begin
79: --

Line 137: pay_assignment_actions act

133: update pay_payroll_actions pac
134: set pac.date_earned = (
135: select pa2.date_earned
136: from pay_payroll_actions pa2,
137: pay_assignment_actions act
138: where act.assignment_action_id = l_qpp_locked_action_id
139: and pa2.payroll_action_id = act.payroll_action_id)
140:
141: where pac.payroll_action_id =p_payroll_action_id;

Line 424: , pay_assignment_actions aga

420: cursor csr_pay_act is
421:
422: select 'Y'
423: from pay_payroll_actions pya
424: , pay_assignment_actions aga
425: where pya.payroll_action_id = p_target_payroll_action_id
426: and pya.action_type = 'Q'
427: and aga.payroll_action_id = pya.payroll_action_id
428: and aga.action_status in ('C', 'S');

Line 666: , pay_assignment_actions aga

662: , pya.target_payroll_action_id
663: , aga.object_version_number
664: , pya.object_version_number
665: from pay_payroll_actions pya
666: , pay_assignment_actions aga
667: where /* Payroll action lock */
668: pya.payroll_action_id = p_payroll_action_id
669: and pya.action_type = 'X'
670: /* Assignment action lock */

Line 1278: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

1274:
1275: -- These variables are set by inserting the assignment action.
1276: -- The values are returned from this procedure.
1277: --
1278: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1279: l_object_version_number pay_assignment_actions.object_version_number%TYPE;
1280: --
1281: Begin
1282: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1279: l_object_version_number pay_assignment_actions.object_version_number%TYPE;

1275: -- These variables are set by inserting the assignment action.
1276: -- The values are returned from this procedure.
1277: --
1278: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1279: l_object_version_number pay_assignment_actions.object_version_number%TYPE;
1280: --
1281: Begin
1282: hr_utility.set_location('Entering:'||l_proc, 5);
1283: --

Line 1582: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

1578:
1579: --
1580: -- These variables are set by post_insert and returned from this procedure
1581: --
1582: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1583: l_a_object_version_number pay_assignment_actions.object_version_number%TYPE;
1584: --
1585: Begin
1586: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1583: l_a_object_version_number pay_assignment_actions.object_version_number%TYPE;

1579: --
1580: -- These variables are set by post_insert and returned from this procedure
1581: --
1582: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1583: l_a_object_version_number pay_assignment_actions.object_version_number%TYPE;
1584: --
1585: Begin
1586: hr_utility.set_location('Entering:'||l_proc, 5);
1587: --