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.PYGBEXC dependencies on PER_TIME_PERIODS

Line 112: FROM per_time_periods ptp

108:
109: /* 11887149 begin
110: SELECT ptp.end_date
111: INTO p_expiry_information
112: FROM per_time_periods ptp
113: ,pay_payroll_actions ppa
114: WHERE ppa.payroll_action_id = p_owner_payroll_action_id
115: AND ppa.time_period_id = ptp.time_period_id; */
116:

Line 120: FROM per_time_periods ptp

116:
117: --To take care of offset payrolls
118: SELECT ptp.end_date
119: INTO p_expiry_information
120: FROM per_time_periods ptp
121: ,pay_payroll_actions ppa
122: WHERE ppa.payroll_action_id = p_owner_payroll_action_id
123: AND ppa.payroll_id = ptp.payroll_id
124: AND ppa.effective_date between ptp.START_DATE and ptp.END_DATE;

Line 173: from per_time_periods PTP,

169: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
170: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
171: -1,-1,0)),'DD-MM-YYYY') finyear, BACT.payroll_id
172: into l_tax_year_start, l_user_payroll_id
173: from per_time_periods PTP,
174: pay_payroll_actions BACT
175: where BACT.payroll_action_id = p_user_payroll_action_id
176: and PTP.time_period_id = BACT.time_period_id;
177: --

Line 183: per_time_periods PTP

179: --
180: select regular_payment_date
181: into l_owning_regular_payment_date
182: from pay_payroll_actions PACT,
183: per_time_periods PTP
184: where PACT.payroll_action_id = p_owner_payroll_action_id
185: and PTP.time_period_id = PACT.time_period_id;
186: --
187: if l_owning_regular_payment_date < l_tax_year_start then

Line 228: FROM per_time_periods PTP,

224: + decode(sign( PTP.regular_payment_date -
225: to_date('06-04-'|| to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
226: -1,0,1)),'DD-MM-YYYY') finyear_end
227: INTO p_expiry_information
228: FROM per_time_periods PTP,
229: pay_payroll_actions BACT
230: WHERE BACT.payroll_action_id = p_owner_payroll_action_id
231: AND PTP.time_period_id = BACT.time_period_id;
232:

Line 281: from per_time_periods PTP,

277: + decode(sign( PTP.regular_payment_date - to_date('01-04-'
278: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
279: -1,-1,0)),'DD-MM-YYYY') finyear, BACT.payroll_id
280: into l_tax_year_start, l_user_payroll_id
281: from per_time_periods PTP,
282: pay_payroll_actions BACT
283: where BACT.payroll_action_id = p_user_payroll_action_id
284: and PTP.time_period_id = BACT.time_period_id;
285: --

Line 291: per_time_periods PTP

287: --
288: select regular_payment_date
289: into l_owning_regular_payment_date
290: from pay_payroll_actions PACT,
291: per_time_periods PTP
292: where PACT.payroll_action_id = p_owner_payroll_action_id
293: and PTP.time_period_id = PACT.time_period_id;
294: --
295: if l_owning_regular_payment_date < l_tax_year_start then

Line 335: FROM per_time_periods PTP,

331: + decode(sign( PTP.regular_payment_date -
332: to_date('01-04-'|| to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
333: -1,0,1)),'DD-MM-YYYY') finyear_end
334: INTO p_expiry_information
335: FROM per_time_periods PTP,
336: pay_payroll_actions BACT
337: WHERE BACT.payroll_action_id = p_owner_payroll_action_id
338: AND PTP.time_period_id = BACT.time_period_id;
339:

Line 453: per_time_periods PTP

449: -- find the regular payment date for the using action
450: select regular_payment_date, BACT.business_group_id
451: into l_user_regular_payment_date, l_business_group_id
452: from pay_payroll_actions BACT,
453: per_time_periods PTP
454: where BACT.payroll_action_id = p_user_payroll_action_id
455: and PTP.time_period_id = BACT.time_period_id;
456:
457: -- find the regular payment date for the owning action

Line 461: per_time_periods PTP

457: -- find the regular payment date for the owning action
458: select regular_payment_date
459: into l_owning_regular_payment_date
460: from pay_payroll_actions PACT,
461: per_time_periods PTP
462: where PACT.payroll_action_id = p_owner_payroll_action_id
463: and PTP.time_period_id = PACT.time_period_id;
464:
465: -- find when the dimension last cleared down

Line 514: per_time_periods PTP

510: -- find the regular payment date for the owning action
511: select regular_payment_date
512: into l_owning_regular_payment_date
513: from pay_payroll_actions PACT,
514: per_time_periods PTP
515: where PACT.payroll_action_id = p_owner_payroll_action_id
516: and PTP.time_period_id = PACT.time_period_id;
517:
518: IF SUBSTR(p_dimension_name,31,8) = 'USER-REG' THEN

Line 593: from per_time_periods PTP,

589: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
590: -1,-1,0),2)
591: ),'DD-MM-YYYY') finyear, BACT.payroll_id
592: into l_tax_year_start, l_user_payroll_id
593: from per_time_periods PTP,
594: pay_payroll_actions BACT
595: where BACT.payroll_action_id = p_user_payroll_action_id
596: and PTP.time_period_id = BACT.time_period_id;
597: --

Line 613: from per_time_periods PTP,

609: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
610: -1,0,-1),2)
611: ),'DD-MM-YYYY') finyear, BACT.payroll_id
612: into l_tax_year_start, l_user_payroll_id
613: from per_time_periods PTP,
614: pay_payroll_actions BACT
615: where BACT.payroll_action_id = p_user_payroll_action_id
616: and PTP.time_period_id = BACT.time_period_id;
617:

Line 622: from per_time_periods TP

618: end if;
619: --
620: Select min(TP.start_date)
621: into l_pay_year_start
622: from per_time_periods TP
623: where TP.payroll_id = l_user_payroll_id
624: and TP.regular_payment_date >= l_tax_year_start;
625: --
626: --

Line 665: from per_time_periods PTP,

661: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
662: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
663: -1,-1,0)),'DD-MM-YYYY') finyear
664: into l_tax_year_start
665: from per_time_periods PTP,
666: pay_payroll_actions BACT
667: where BACT.payroll_action_id = p_owner_payroll_action_id
668: and PTP.time_period_id = BACT.time_period_id;
669:

Line 738: per_time_periods PTP

734: --
735: select regular_payment_date
736: into l_owning_regular_payment_date
737: from pay_payroll_actions PACT,
738: per_time_periods PTP
739: where PACT.payroll_action_id = p_owner_payroll_action_id
740: and PTP.time_period_id = PACT.time_period_id;
741: --
742: -- check that the beginning of the Person Level Period is before the

Line 782: from per_time_periods PTP,

778: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
779: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
780: -1,-1,0)),'DD-MM-YYYY') finyear
781: into l_tax_year_start
782: from per_time_periods PTP,
783: pay_payroll_actions ppa,
784: pay_assignment_actions paa
785: where ppa.payroll_action_id = paa.payroll_action_id
786: and paa.assignment_action_id = p_asg_action

Line 822: from per_time_periods PTP,

818: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
819: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
820: -1,-1,0)),'DD-MM-YYYY') finyear
821: into l_tax_year_start
822: from per_time_periods PTP,
823: pay_payroll_actions ppa,
824: pay_assignment_actions paa
825: where ppa.payroll_action_id = paa.payroll_action_id
826: and paa.assignment_action_id = p_asg_action

Line 873: from per_time_periods PTP,

869: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
870: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
871: -1,-1,0)),'DD-MM-YYYY') finyear
872: into l_tax_year_start
873: from per_time_periods PTP,
874: pay_payroll_actions ppa,
875: pay_assignment_actions paa
876: where ppa.payroll_action_id = paa.payroll_action_id
877: and paa.assignment_action_id = p_asg_action

Line 923: from per_time_periods PTP,

919: + decode(sign( PTP.regular_payment_date - to_date('01-04-'
920: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
921: -1,-1,0)),'DD-MM-YYYY') finyear
922: into l_tax_year_start
923: from per_time_periods PTP,
924: pay_payroll_actions ppa,
925: pay_assignment_actions paa
926: where ppa.payroll_action_id = paa.payroll_action_id
927: and paa.assignment_action_id = p_asg_action