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 PAY_PAYROLL_ACTIONS

Line 70: from pay_payroll_actions

66: */
67:
68: select time_period_id
69: into l_user_time_period_id
70: from pay_payroll_actions
71: where payroll_action_id = p_user_payroll_action_id;
72:
73: select time_period_id
74: into l_owner_time_period_id

Line 75: from pay_payroll_actions

71: where payroll_action_id = p_user_payroll_action_id;
72:
73: select time_period_id
74: into l_owner_time_period_id
75: from pay_payroll_actions
76: where payroll_action_id = p_owner_payroll_action_id;
77:
78: if l_user_time_period_id = l_owner_time_period_id then
79: p_expiry_information := 0;

Line 113: ,pay_payroll_actions ppa

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:
117: --To take care of offset payrolls

Line 121: ,pay_payroll_actions ppa

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;
125: --11887149 end;

Line 174: pay_payroll_actions BACT

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: --
178: -- find the regular payment date for the owning action

Line 182: from pay_payroll_actions PACT,

178: -- find the regular payment date for the owning action
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: --

Line 229: pay_payroll_actions BACT

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:
233: hr_utility.set_location ('p_expiry_information:'||p_expiry_information,10);

Line 282: pay_payroll_actions BACT

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: --
286: -- find the regular payment date for the owning action

Line 290: from pay_payroll_actions PACT,

286: -- find the regular payment date for the owning action
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: --

Line 336: pay_payroll_actions BACT

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:
340: hr_utility.set_location ('p_expiry_information:'||p_expiry_information,10);

Line 374: from pay_payroll_actions BACT

370: + decode(sign( p_user_effective_date - to_date('06-04-'
371: || to_char( p_user_effective_date,'YYYY'),'DD-MM-YYYY')),
372: -1,-1,0)),'DD-MM-YYYY')
373: into l_tax_year_start
374: from pay_payroll_actions BACT
375: where BACT.payroll_action_id = p_user_payroll_action_id;
376: --
377: if p_owner_effective_date < l_tax_year_start then
378: p_expiry_information := 1;

Line 452: from pay_payroll_actions BACT,

448:
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:

Line 460: from pay_payroll_actions PACT,

456:
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:

Line 513: from pay_payroll_actions PACT,

509:
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:

Line 594: pay_payroll_actions BACT

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: --
598: elsif p_dimension_name in ('_ASG_TD_EVEN_TWO_YTD','_PER_TD_EVEN_TWO_YTD') then

Line 614: pay_payroll_actions BACT

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:
618: end if;

Line 666: pay_payroll_actions BACT

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:
670:

Line 737: from pay_payroll_actions PACT,

733: -- find the regular payment date for the owning action
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: --

Line 783: pay_payroll_actions ppa,

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
787: and ppa.payroll_id = p_payroll_id

Line 823: pay_payroll_actions ppa,

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
827: and ppa.payroll_id = p_payroll_id

Line 874: pay_payroll_actions ppa,

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
878: and ppa.payroll_id = p_payroll_id

Line 924: pay_payroll_actions ppa,

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
928: and ppa.payroll_id = p_payroll_id