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 126: from per_time_periods PTP,

122: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
123: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
124: -1,-1,0)),'DD-MM-YYYY') finyear, BACT.payroll_id
125: into l_tax_year_start, l_user_payroll_id
126: from per_time_periods PTP,
127: pay_payroll_actions BACT
128: where BACT.payroll_action_id = p_user_payroll_action_id
129: and PTP.time_period_id = BACT.time_period_id;
130: --

Line 136: per_time_periods PTP

132: --
133: select regular_payment_date
134: into l_owning_regular_payment_date
135: from pay_payroll_actions PACT,
136: per_time_periods PTP
137: where PACT.payroll_action_id = p_owner_payroll_action_id
138: and PTP.time_period_id = PACT.time_period_id;
139: --
140: if l_owning_regular_payment_date < l_tax_year_start then

Line 196: from per_time_periods PTP,

192: + decode(sign( PTP.regular_payment_date - to_date('01-04-'
193: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
194: -1,-1,0)),'DD-MM-YYYY') finyear, BACT.payroll_id
195: into l_tax_year_start, l_user_payroll_id
196: from per_time_periods PTP,
197: pay_payroll_actions BACT
198: where BACT.payroll_action_id = p_user_payroll_action_id
199: and PTP.time_period_id = BACT.time_period_id;
200: --

Line 206: per_time_periods PTP

202: --
203: select regular_payment_date
204: into l_owning_regular_payment_date
205: from pay_payroll_actions PACT,
206: per_time_periods PTP
207: where PACT.payroll_action_id = p_owner_payroll_action_id
208: and PTP.time_period_id = PACT.time_period_id;
209: --
210: if l_owning_regular_payment_date < l_tax_year_start then

Line 300: per_time_periods PTP

296: -- find the regular payment date for the using action
297: select regular_payment_date, BACT.business_group_id
298: into l_user_regular_payment_date, l_business_group_id
299: from pay_payroll_actions BACT,
300: per_time_periods PTP
301: where BACT.payroll_action_id = p_user_payroll_action_id
302: and PTP.time_period_id = BACT.time_period_id;
303:
304: -- find the regular payment date for the owning action

Line 308: per_time_periods PTP

304: -- find the regular payment date for the owning action
305: select regular_payment_date
306: into l_owning_regular_payment_date
307: from pay_payroll_actions PACT,
308: per_time_periods PTP
309: where PACT.payroll_action_id = p_owner_payroll_action_id
310: and PTP.time_period_id = PACT.time_period_id;
311:
312: -- find when the dimension last cleared down

Line 386: from per_time_periods PTP,

382: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
383: -1,-1,0),2)
384: ),'DD-MM-YYYY') finyear, BACT.payroll_id
385: into l_tax_year_start, l_user_payroll_id
386: from per_time_periods PTP,
387: pay_payroll_actions BACT
388: where BACT.payroll_action_id = p_user_payroll_action_id
389: and PTP.time_period_id = BACT.time_period_id;
390: --

Line 406: from per_time_periods PTP,

402: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
403: -1,0,-1),2)
404: ),'DD-MM-YYYY') finyear, BACT.payroll_id
405: into l_tax_year_start, l_user_payroll_id
406: from per_time_periods PTP,
407: pay_payroll_actions BACT
408: where BACT.payroll_action_id = p_user_payroll_action_id
409: and PTP.time_period_id = BACT.time_period_id;
410:

Line 415: from per_time_periods TP

411: end if;
412: --
413: Select min(TP.start_date)
414: into l_pay_year_start
415: from per_time_periods TP
416: where TP.payroll_id = l_user_payroll_id
417: and TP.regular_payment_date >= l_tax_year_start;
418: --
419: --

Line 462: per_time_periods PTP

458: --
459: select regular_payment_date
460: into l_owning_regular_payment_date
461: from pay_payroll_actions PACT,
462: per_time_periods PTP
463: where PACT.payroll_action_id = p_owner_payroll_action_id
464: and PTP.time_period_id = PACT.time_period_id;
465: --
466: -- check that the beginning of the Person Level Period is before the

Line 506: from per_time_periods PTP,

502: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
503: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
504: -1,-1,0)),'DD-MM-YYYY') finyear
505: into l_tax_year_start
506: from per_time_periods PTP,
507: pay_payroll_actions ppa,
508: pay_assignment_actions paa
509: where ppa.payroll_action_id = paa.payroll_action_id
510: and paa.assignment_action_id = p_asg_action

Line 546: from per_time_periods PTP,

542: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
543: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
544: -1,-1,0)),'DD-MM-YYYY') finyear
545: into l_tax_year_start
546: from per_time_periods PTP,
547: pay_payroll_actions ppa,
548: pay_assignment_actions paa
549: where ppa.payroll_action_id = paa.payroll_action_id
550: and paa.assignment_action_id = p_asg_action

Line 597: from per_time_periods PTP,

593: + decode(sign( PTP.regular_payment_date - to_date('06-04-'
594: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
595: -1,-1,0)),'DD-MM-YYYY') finyear
596: into l_tax_year_start
597: from per_time_periods PTP,
598: pay_payroll_actions ppa,
599: pay_assignment_actions paa
600: where ppa.payroll_action_id = paa.payroll_action_id
601: and paa.assignment_action_id = p_asg_action

Line 647: from per_time_periods PTP,

643: + decode(sign( PTP.regular_payment_date - to_date('01-04-'
644: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
645: -1,-1,0)),'DD-MM-YYYY') finyear
646: into l_tax_year_start
647: from per_time_periods PTP,
648: pay_payroll_actions ppa,
649: pay_assignment_actions paa
650: where ppa.payroll_action_id = paa.payroll_action_id
651: and paa.assignment_action_id = p_asg_action