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.HR_PYOINT dependencies on PAY_PAYROLL_ACTIONS

Line 73: from pay_payroll_actions pa1,

69: cursor c_indep(pactid in number, assignid in number) is
70: select 1,
71: pa1.effective_date,
72: pa2.effective_date
73: from pay_payroll_actions pa1,
74: pay_payroll_actions pa2,
75: pay_action_classifications pcl,
76: pay_assignment_actions ac2
77: where pa1.payroll_action_id = pactid

Line 74: pay_payroll_actions pa2,

70: select 1,
71: pa1.effective_date,
72: pa2.effective_date
73: from pay_payroll_actions pa1,
74: pay_payroll_actions pa2,
75: pay_action_classifications pcl,
76: pay_assignment_actions ac2
77: where pa1.payroll_action_id = pactid
78: and ac2.assignment_id = assignid

Line 93: pay_payroll_actions pa1,

89: pa1.effective_date,
90: pa2.effective_date,
91: as1.assignment_number
92: from per_assignments_f as1,
93: pay_payroll_actions pa1,
94: pay_payroll_actions pa2,
95: pay_action_classifications pcl,
96: pay_assignment_actions ac2,
97: pay_object_groups pog_act,

Line 94: pay_payroll_actions pa2,

90: pa2.effective_date,
91: as1.assignment_number
92: from per_assignments_f as1,
93: pay_payroll_actions pa1,
94: pay_payroll_actions pa2,
95: pay_action_classifications pcl,
96: pay_assignment_actions ac2,
97: pay_object_groups pog_act,
98: pay_object_groups pog_grp

Line 123: pay_payroll_actions pa1,

119: pa2.effective_date,
120: as1.assignment_number
121: from per_assignments_f as1,
122: per_assignments_f as2,
123: pay_payroll_actions pa1,
124: pay_payroll_actions pa2,
125: pay_action_classifications pcl,
126: pay_assignment_actions ac2,
127: per_periods_of_service pos

Line 124: pay_payroll_actions pa2,

120: as1.assignment_number
121: from per_assignments_f as1,
122: per_assignments_f as2,
123: pay_payroll_actions pa1,
124: pay_payroll_actions pa2,
125: pay_action_classifications pcl,
126: pay_assignment_actions ac2,
127: per_periods_of_service pos
128: where pa1.payroll_action_id = pactid

Line 157: from pay_payroll_actions ppa,

153: hr_utility.set_location('hr_pyoint.validate',2);
154: if(not c_indep%NOTFOUND) then
155: select ass.assignment_number
156: into assnum
157: from pay_payroll_actions ppa,
158: per_assignments_f ass
159: where ppa.payroll_action_id = pactid
160: and ass.assignment_id = assignid
161: and ass.payroll_id = ppa.payroll_id