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_AE_CHEQUE_REPORT dependencies on PER_ALL_ASSIGNMENTS_F

Line 77: from pay_assignment_actions paa , per_all_assignments_f paf, hr_all_organization_units hou, per_all_people_f ppf

73:
74:
75: CURSOR csr_get_assact_det_ORG (l_pact_id number , l_date date) IS
76: select paa.assignment_action_id , paa.assignment_id
77: from pay_assignment_actions paa , per_all_assignments_f paf, hr_all_organization_units hou, per_all_people_f ppf
78: where paa.payroll_action_id = p_pact_id
79: and paa.action_status = 'C'
80: and not exists ( select 1
81: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

Line 89: AND paf.effective_start_date = (select max(paf1.effective_start_date) from per_all_assignments_f paf1

85: and ppa1.action_type = 'D'
86: and ppa1.action_status = 'C'
87: and paa1.action_status = 'C')
88: and paa.assignment_id = paf.assignment_id
89: AND paf.effective_start_date = (select max(paf1.effective_start_date) from per_all_assignments_f paf1
90: where paf1.assignment_id = paf.assignment_id)
91: AND trunc(l_date,'MM') between trunc(paf.effective_start_date,'MM') and paf.effective_end_date
92: and paf.person_id = ppf.person_id
93: AND ppf.effective_start_date = (select max(ppf1.effective_start_date) from per_all_people_f ppf1

Line 106: from pay_assignment_actions paa , per_all_assignments_f paf, per_all_people_f ppf

102: /* Cursor for fetching assignment action id and assignment id for current payroll action id order by emp no*/
103:
104: CURSOR csr_get_assact_det_EMPNO (l_pact_id number , l_date date) IS
105: select paa.assignment_action_id , paa.assignment_id
106: from pay_assignment_actions paa , per_all_assignments_f paf, per_all_people_f ppf
107: where paa.payroll_action_id = p_pact_id
108: and paa.action_status = 'C'
109: and not exists ( select 1
110: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

Line 118: and paf.effective_start_date = (select max(paf1.effective_start_date) from per_all_assignments_f paf1

114: and ppa1.action_type = 'D'
115: and ppa1.action_status = 'C'
116: and paa1.action_status = 'C')
117: and paa.assignment_id = paf.assignment_id
118: and paf.effective_start_date = (select max(paf1.effective_start_date) from per_all_assignments_f paf1
119: where paf1.assignment_id = paf.assignment_id)
120: and trunc(l_date,'MM') between trunc(paf.effective_start_date,'MM') and paf.effective_end_date
121: and paf.person_id = ppf.person_id
122: and ppf.effective_start_date = (select max(ppf1.effective_start_date) from per_all_people_f ppf1

Line 133: per_all_people_f ppf, per_all_assignments_f paf

129:
130: CURSOR csr_get_assact_det_PD (l_pact_id number,l_date date) IS
131: select paa.assignment_action_id , paa.assignment_id
132: from pay_assignment_actions paa , pay_payroll_actions ppa , pay_pre_payments ppp , pay_assignment_actions paa1,
133: per_all_people_f ppf, per_all_assignments_f paf
134: where paa.payroll_action_id = p_pact_id
135: and paa.action_status IN ('C','S')
136: and not exists ( select 1
137: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

Line 151: and paf.effective_start_date = (select max(paf1.effective_start_date) from per_all_assignments_f paf1

147: and ppa.payroll_action_id = paa1.payroll_action_id
148: and ppa.action_status = 'C'
149: and ppa.action_type in ('P','U')
150: and paa.assignment_id = paf.assignment_id
151: and paf.effective_start_date = (select max(paf1.effective_start_date) from per_all_assignments_f paf1
152: where paf1.assignment_id = paf.assignment_id)
153: and trunc(l_date,'MM') between trunc(paf.effective_start_date,'MM') and paf.effective_end_date
154: and paf.person_id = ppf.person_id
155: and ppf.effective_start_date = (select max(ppf1.effective_start_date) from per_all_people_f ppf1

Line 165: FROM per_all_people_f ppf, per_all_assignments_f paf

161: /* Cursor for fetching the details for the assignments */
162:
163: CURSOR csr_get_per_det (l_assignment_id number , l_date date) IS
164: SELECT ppf.full_name , ppf.employee_number , paf.job_id , paf.organization_id
165: FROM per_all_people_f ppf, per_all_assignments_f paf
166: WHERE paf.assignment_id = l_assignment_id
167: AND paf.person_id = ppf.person_id
168: AND paf.effective_start_date = (select max(paf1.effective_start_date) from per_all_assignments_f paf1
169: where paf1.assignment_id = paf.assignment_id)

Line 168: AND paf.effective_start_date = (select max(paf1.effective_start_date) from per_all_assignments_f paf1

164: SELECT ppf.full_name , ppf.employee_number , paf.job_id , paf.organization_id
165: FROM per_all_people_f ppf, per_all_assignments_f paf
166: WHERE paf.assignment_id = l_assignment_id
167: AND paf.person_id = ppf.person_id
168: AND paf.effective_start_date = (select max(paf1.effective_start_date) from per_all_assignments_f paf1
169: where paf1.assignment_id = paf.assignment_id)
170: AND trunc(l_date,'MM') between trunc(paf.effective_start_date,'MM') and paf.effective_end_date
171: AND ppf.effective_start_date = (select max(ppf1.effective_start_date) from per_all_people_f ppf1
172: where ppf1.person_id = ppf.person_id)