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_PAYROLL_REGISTER dependencies on PER_TIME_PERIODS

Line 161: FROM per_time_periods ptp

157: /* Modifyig the cursor for performance issue for Bug 7597523 */
158: /*CURSOR csr_get_orgs_for_payroll (l_payroll_id number , l_effective_date date) is
159: SELECT distinct pai_emp.action_information15 organization
160: ,ppf.payroll_id
161: FROM per_time_periods ptp
162: ,pay_action_information pai_emp
163: ,pay_assignment_actions paa1
164: ,pay_action_interlocks lck
165: ,pay_payroll_actions ppa1

Line 184: FROM per_time_periods ptp

180:
181: CURSOR csr_get_orgs_for_payroll (l_payroll_id number , l_effective_date date) is
182: SELECT distinct pai_emp.action_information15 organization
183: ,ppf.payroll_id
184: FROM per_time_periods ptp
185: ,pay_action_information pai_emp
186: ,pay_assignment_actions paa1
187: ,pay_payroll_actions ppa1
188: ,pay_all_payrolls_f ppf

Line 208: FROM per_time_periods ptp

204: /* Modifyig the cursor for performance issue for Bug 7597523 */
205: /*cursor csr_condition_one(l_organization_id number ,l_org_structure_version_id number,l_parent_id number, l_effective_date date ) is
206: SELECT distinct pai_emp.action_information15 organization
207: ,ppf.payroll_id
208: FROM per_time_periods ptp
209: ,pay_action_information pai_emp
210: ,pay_assignment_actions paa1
211: ,pay_action_interlocks lck
212: ,pay_payroll_actions ppa1

Line 241: FROM per_time_periods ptp

237: from sys.dual) ; */
238: cursor csr_condition_one(l_organization_id number ,l_org_structure_version_id number,l_parent_id number, l_effective_date date ) is
239: SELECT distinct pai_emp.action_information15 organization
240: ,ppf.payroll_id
241: FROM per_time_periods ptp
242: ,pay_action_information pai_emp
243: ,pay_assignment_actions paa1
244: ,pay_payroll_actions ppa1
245: ,pay_all_payrolls_f ppf

Line 275: FROM per_time_periods ptp

271: /* Modifyig the cursor for performance issue for Bug 7597523 */
272: /*cursor csr_condition_two(l_organization_id number , l_effective_date date) is
273: SELECT distinct pai_emp.action_information15 organization
274: ,ppf.payroll_id
275: FROM per_time_periods ptp
276: ,pay_action_information pai_emp
277: ,pay_assignment_actions paa1
278: ,pay_action_interlocks lck
279: ,pay_payroll_actions ppa1

Line 298: FROM per_time_periods ptp

294:
295: cursor csr_condition_two(l_organization_id number , l_effective_date date) is
296: SELECT distinct pai_emp.action_information15 organization
297: ,ppf.payroll_id
298: FROM per_time_periods ptp
299: ,pay_action_information pai_emp
300: ,pay_assignment_actions paa1
301: ,pay_payroll_actions ppa1
302: ,pay_all_payrolls_f ppf

Line 321: FROM per_time_periods ptp

317: /* It looks like dummy cursor as it has conditions 1=2 */
318: /*cursor csr_condition_three(l_effective_date date) is
319: SELECT distinct pai_emp.action_information15 organization
320: ,ppf.payroll_id
321: FROM per_time_periods ptp
322: ,pay_action_information pai_emp
323: ,pay_assignment_actions paa1
324: ,pay_action_interlocks lck
325: ,pay_payroll_actions ppa1

Line 350: FROM per_time_periods ptp

346: /* CURSOR TO GET PAYROLL IDS DISTINCT */
347: /* Modifyig the cursor for performance issue for Bug 7597523 */
348: /*cursor csr_distinct_pyrl(l_organization_id number ,l_org_structure_version_id number,l_parent_id number, l_effective_date date ) is
349: SELECT distinct ppf.payroll_id
350: FROM per_time_periods ptp
351: ,pay_action_information pai_emp
352: ,pay_assignment_actions paa1
353: ,pay_action_interlocks lck
354: ,pay_payroll_actions ppa1

Line 382: FROM per_time_periods ptp

378: union select to_char(nvl(l_organization_id,l_parent_id))
379: from sys.dual) ; */
380: cursor csr_distinct_pyrl(l_organization_id number ,l_org_structure_version_id number,l_parent_id number, l_effective_date date ) is
381: SELECT distinct ppf.payroll_id
382: FROM per_time_periods ptp
383: ,pay_action_information pai_emp
384: ,pay_assignment_actions paa1
385: ,pay_payroll_actions ppa1
386: ,pay_all_payrolls_f ppf

Line 414: FROM per_time_periods ptp

410: from sys.dual) ;
411: /* CURSOR TO GET PAYROLL IDS DISTINCT FOR ORGANIZATION */
412: cursor csr_org_only_distinct_pyrl(l_organization_id number , l_effective_date date) is
413: SELECT distinct ppf.payroll_id
414: FROM per_time_periods ptp
415: ,pay_action_information pai_emp
416: ,pay_assignment_actions paa1
417: ,pay_action_interlocks lck
418: ,pay_payroll_actions ppa1

Line 461: FROM per_time_periods ptp

457: ,pai_emp1.action_information11
458: ,ppf.payroll_name
459: ,nvl(pai_emp1.action_information13,0) ytd_earning
460: ,nvl(pai_emp1.action_information4,0) ytd_deduction
461: FROM per_time_periods ptp
462: ,pay_action_information pai_emp
463: ,pay_action_information pai_emp1
464: ,pay_assignment_actions paa1
465: ,pay_action_interlocks lck

Line 505: FROM per_time_periods ptp

501: ,pai_emp1.action_information11
502: ,ppf.payroll_name
503: ,nvl(pai_emp1.action_information13,0) ytd_earning
504: ,nvl(pai_emp1.action_information4,0) ytd_deduction
505: FROM per_time_periods ptp
506: ,pay_action_information pai_emp
507: ,pay_action_information pai_emp1
508: ,pay_assignment_actions paa1
509: ,pay_payroll_actions ppa1

Line 668: FROM per_time_periods ptp

664: AND pay_v.action_context_id = paa.assignment_action_id
665: AND pay_v.narrative = pai_ele.action_information4
666: AND pay_v.payment_type NOT IN ('F')
667: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
668: FROM per_time_periods ptp
669: ,pay_action_information pai_emp
670: ,pay_assignment_actions paa1
671: ,pay_action_interlocks lck
672: ,pay_payroll_actions ppa1

Line 707: FROM per_time_periods ptp

703: AND pet.element_type_id = pai_ele.action_information2
704: AND pai_ele.action_information5 NOT IN ('F')
705: AND pet.input_value_id = pai_ele.action_information3
706: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
707: FROM per_time_periods ptp
708: ,pay_action_information pai_emp
709: ,pay_assignment_actions paa1
710: ,pay_action_interlocks lck
711: ,pay_payroll_actions ppa1

Line 736: ,per_time_periods ptp

732: AND ptp.end_date = l_effective_date);
733: --CURSOR csr_get_sum_earn_only_org (l_organization_id number , l_payroll_id number , l_effective_date date) IS
734: /*SELECT sum(pay_v.numeric_value)
735: FROM pay_assignment_actions paa
736: ,per_time_periods ptp
737: ,pay_assignment_actions paa1
738: ,pay_action_interlocks lck
739: ,pay_payroll_actions ppa1
740: ,pay_action_information pai_ele

Line 780: from per_time_periods ptp

776: and pay_v.narrative = pai_ele.action_information4
777: and pay_v.payment_type not in ('F')
778: and paa.assignment_action_id in (
779: select pai_emp.action_context_id arch_assact
780: from per_time_periods ptp
781: ,pay_action_information pai_emp
782: ,pay_assignment_actions paa1
783: ,pay_action_interlocks lck
784: ,pay_payroll_actions ppa1

Line 802: from per_time_periods ptp

798: and ptp.end_date = l_effective_date);
799: */
800: CURSOR csr_SEOO_SPLIT_1 (l_organization_id number , l_payroll_id number , l_effective_date date) IS
801: select pai_emp.action_context_id arch_assact
802: from per_time_periods ptp
803: ,pay_action_information pai_emp
804: ,pay_assignment_actions paa1
805: ,pay_action_interlocks lck
806: ,pay_payroll_actions ppa1

Line 865: FROM per_time_periods ptp

861: AND pay_v.action_context_id = paa.assignment_action_id
862: AND pay_v.narrative = pai_ele.action_information4
863: AND pay_v.payment_type NOT IN ('F')
864: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
865: FROM per_time_periods ptp
866: ,pay_action_information pai_emp
867: ,pay_assignment_actions paa1
868: ,pay_action_interlocks lck
869: ,pay_payroll_actions ppa1

Line 904: FROM per_time_periods ptp

900: AND pet.element_type_id = pai_ele.action_information2
901: AND pai_ele.action_information5 NOT IN ('F')
902: AND pet.input_value_id = pai_ele.action_information3
903: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
904: FROM per_time_periods ptp
905: ,pay_action_information pai_emp
906: ,pay_assignment_actions paa1
907: ,pay_action_interlocks lck
908: ,pay_payroll_actions ppa1

Line 933: ,per_time_periods ptp

929: AND ptp.end_date = l_effective_date);
930: --CURSOR csr_get_sum_ded_only_org (l_organization_id number , l_payroll_id number , l_effective_date date) IS
931: /*SELECT sum(pay_v.numeric_value)
932: FROM pay_assignment_actions paa
933: ,per_time_periods ptp
934: ,pay_assignment_actions paa1
935: ,pay_action_interlocks lck
936: ,pay_payroll_actions ppa1
937: ,pay_action_information pai_ele

Line 976: from per_time_periods ptp

972: and pay_v.narrative = pai_ele.action_information4
973: and pay_v.payment_type not in ('F')
974: and paa.assignment_action_id in (
975: select pai_emp.action_context_id arch_assact
976: from per_time_periods ptp
977: ,pay_action_information pai_emp
978: ,pay_assignment_actions paa1
979: ,pay_action_interlocks lck
980: ,pay_payroll_actions ppa1

Line 997: from per_time_periods ptp

993: and paa1.action_status = 'C'
994: and ptp.end_date = l_effective_date);*/
995: CURSOR csr_SDOO_SPLIT_1 (l_organization_id number , l_payroll_id number , l_effective_date date) IS
996: select pai_emp.action_context_id arch_assact
997: from per_time_periods ptp
998: ,pay_action_information pai_emp
999: ,pay_assignment_actions paa1
1000: ,pay_action_interlocks lck
1001: ,pay_payroll_actions ppa1