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 160: FROM per_time_periods ptp

156: /* SELECTS ORGANIZATIONS COMING UNDER A PAYROLL */
157: CURSOR csr_get_orgs_for_payroll (l_payroll_id number , l_effective_date date) is
158: SELECT distinct pai_emp.action_information15 organization
159: ,ppf.payroll_id
160: FROM per_time_periods ptp
161: ,pay_action_information pai_emp
162: ,pay_assignment_actions paa1
163: ,pay_action_interlocks lck
164: ,pay_payroll_actions ppa1

Line 183: FROM per_time_periods ptp

179: /* CURSOR ONE */
180: cursor csr_condition_one(l_organization_id number ,l_org_structure_version_id number,l_parent_id number, l_effective_date date ) is
181: SELECT distinct pai_emp.action_information15 organization
182: ,ppf.payroll_id
183: FROM per_time_periods ptp
184: ,pay_action_information pai_emp
185: ,pay_assignment_actions paa1
186: ,pay_action_interlocks lck
187: ,pay_payroll_actions ppa1

Line 216: FROM per_time_periods ptp

212: from sys.dual) ;
213: cursor csr_condition_two(l_organization_id number , l_effective_date date) is
214: SELECT distinct pai_emp.action_information15 organization
215: ,ppf.payroll_id
216: FROM per_time_periods ptp
217: ,pay_action_information pai_emp
218: ,pay_assignment_actions paa1
219: ,pay_action_interlocks lck
220: ,pay_payroll_actions ppa1

Line 238: FROM per_time_periods ptp

234: AND pai_emp.action_information2 = l_organization_id;
235: cursor csr_condition_three(l_effective_date date) is
236: SELECT distinct pai_emp.action_information15 organization
237: ,ppf.payroll_id
238: FROM per_time_periods ptp
239: ,pay_action_information pai_emp
240: ,pay_assignment_actions paa1
241: ,pay_action_interlocks lck
242: ,pay_payroll_actions ppa1

Line 260: FROM per_time_periods ptp

256: AND 1 = 2;
257: /* CURSOR TO GET PAYROLL IDS DISTINCT */
258: cursor csr_distinct_pyrl(l_organization_id number ,l_org_structure_version_id number,l_parent_id number, l_effective_date date ) is
259: SELECT distinct ppf.payroll_id
260: FROM per_time_periods ptp
261: ,pay_action_information pai_emp
262: ,pay_assignment_actions paa1
263: ,pay_action_interlocks lck
264: ,pay_payroll_actions ppa1

Line 293: FROM per_time_periods ptp

289: from sys.dual) ;
290: /* CURSOR TO GET PAYROLL IDS DISTINCT FOR ORGANIZATION */
291: cursor csr_org_only_distinct_pyrl(l_organization_id number , l_effective_date date) is
292: SELECT distinct ppf.payroll_id
293: FROM per_time_periods ptp
294: ,pay_action_information pai_emp
295: ,pay_assignment_actions paa1
296: ,pay_action_interlocks lck
297: ,pay_payroll_actions ppa1

Line 339: FROM per_time_periods ptp

335: ,pai_emp1.action_information11
336: ,ppf.payroll_name
337: ,nvl(pai_emp1.action_information13,0) ytd_earning
338: ,nvl(pai_emp1.action_information4,0) ytd_deduction
339: FROM per_time_periods ptp
340: ,pay_action_information pai_emp
341: ,pay_action_information pai_emp1
342: ,pay_assignment_actions paa1
343: ,pay_action_interlocks lck

Line 503: FROM per_time_periods ptp

499: AND pay_v.action_context_id = paa.assignment_action_id
500: AND pay_v.narrative = pai_ele.action_information4
501: AND pay_v.payment_type NOT IN ('F')
502: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
503: FROM per_time_periods ptp
504: ,pay_action_information pai_emp
505: ,pay_assignment_actions paa1
506: ,pay_action_interlocks lck
507: ,pay_payroll_actions ppa1

Line 542: FROM per_time_periods ptp

538: AND pet.element_type_id = pai_ele.action_information2
539: AND pai_ele.action_information5 NOT IN ('F')
540: AND pet.input_value_id = pai_ele.action_information3
541: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
542: FROM per_time_periods ptp
543: ,pay_action_information pai_emp
544: ,pay_assignment_actions paa1
545: ,pay_action_interlocks lck
546: ,pay_payroll_actions ppa1

Line 571: ,per_time_periods ptp

567: AND ptp.end_date = l_effective_date);
568: --CURSOR csr_get_sum_earn_only_org (l_organization_id number , l_payroll_id number , l_effective_date date) IS
569: /*SELECT sum(pay_v.numeric_value)
570: FROM pay_assignment_actions paa
571: ,per_time_periods ptp
572: ,pay_assignment_actions paa1
573: ,pay_action_interlocks lck
574: ,pay_payroll_actions ppa1
575: ,pay_action_information pai_ele

Line 615: from per_time_periods ptp

611: and pay_v.narrative = pai_ele.action_information4
612: and pay_v.payment_type not in ('F')
613: and paa.assignment_action_id in (
614: select pai_emp.action_context_id arch_assact
615: from per_time_periods ptp
616: ,pay_action_information pai_emp
617: ,pay_assignment_actions paa1
618: ,pay_action_interlocks lck
619: ,pay_payroll_actions ppa1

Line 637: from per_time_periods ptp

633: and ptp.end_date = l_effective_date);
634: */
635: CURSOR csr_SEOO_SPLIT_1 (l_organization_id number , l_payroll_id number , l_effective_date date) IS
636: select pai_emp.action_context_id arch_assact
637: from per_time_periods ptp
638: ,pay_action_information pai_emp
639: ,pay_assignment_actions paa1
640: ,pay_action_interlocks lck
641: ,pay_payroll_actions ppa1

Line 700: FROM per_time_periods ptp

696: AND pay_v.action_context_id = paa.assignment_action_id
697: AND pay_v.narrative = pai_ele.action_information4
698: AND pay_v.payment_type NOT IN ('F')
699: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
700: FROM per_time_periods ptp
701: ,pay_action_information pai_emp
702: ,pay_assignment_actions paa1
703: ,pay_action_interlocks lck
704: ,pay_payroll_actions ppa1

Line 739: FROM per_time_periods ptp

735: AND pet.element_type_id = pai_ele.action_information2
736: AND pai_ele.action_information5 NOT IN ('F')
737: AND pet.input_value_id = pai_ele.action_information3
738: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
739: FROM per_time_periods ptp
740: ,pay_action_information pai_emp
741: ,pay_assignment_actions paa1
742: ,pay_action_interlocks lck
743: ,pay_payroll_actions ppa1

Line 768: ,per_time_periods ptp

764: AND ptp.end_date = l_effective_date);
765: --CURSOR csr_get_sum_ded_only_org (l_organization_id number , l_payroll_id number , l_effective_date date) IS
766: /*SELECT sum(pay_v.numeric_value)
767: FROM pay_assignment_actions paa
768: ,per_time_periods ptp
769: ,pay_assignment_actions paa1
770: ,pay_action_interlocks lck
771: ,pay_payroll_actions ppa1
772: ,pay_action_information pai_ele

Line 811: from per_time_periods ptp

807: and pay_v.narrative = pai_ele.action_information4
808: and pay_v.payment_type not in ('F')
809: and paa.assignment_action_id in (
810: select pai_emp.action_context_id arch_assact
811: from per_time_periods ptp
812: ,pay_action_information pai_emp
813: ,pay_assignment_actions paa1
814: ,pay_action_interlocks lck
815: ,pay_payroll_actions ppa1

Line 832: from per_time_periods ptp

828: and paa1.action_status = 'C'
829: and ptp.end_date = l_effective_date);*/
830: CURSOR csr_SDOO_SPLIT_1 (l_organization_id number , l_payroll_id number , l_effective_date date) IS
831: select pai_emp.action_context_id arch_assact
832: from per_time_periods ptp
833: ,pay_action_information pai_emp
834: ,pay_assignment_actions paa1
835: ,pay_action_interlocks lck
836: ,pay_payroll_actions ppa1