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

Line 91: per_time_periods

87: prd_information1
88: into
89: l_owner_tax_year
90: from
91: per_time_periods
92: where
93: payroll_id = l_owner_payroll_id
94: and
95: l_owner_date_earned between start_date and end_date;

Line 103: per_time_periods

99: prd_information1
100: into
101: l_user_tax_year
102: from
103: per_time_periods
104: where
105: payroll_id = l_user_payroll_id
106: and
107: l_user_date_earned between start_date and end_date;

Line 264: per_time_periods

260: prd_information3
261: into
262: l_owner_cal_year
263: from
264: per_time_periods
265: where
266: payroll_id = l_owner_payroll_id
267: and
268: l_owner_date_earned between start_date and end_date;

Line 276: per_time_periods

272: prd_information3
273: into
274: l_user_cal_year
275: from
276: per_time_periods
277: where
278: payroll_id = l_user_payroll_id
279: and
280: l_user_date_earned between start_date and end_date;

Line 337: ,per_time_periods ptp

333:
334: SELECT max(ptpp.pay_advice_date)
335: INTO p_expiry_information
336: FROM pay_payroll_actions ppa
337: ,per_time_periods ptp
338: ,per_time_periods ptpp
339: WHERE ppa.payroll_action_id = p_owner_payroll_action_id
340: AND ppa.payroll_id = ptp.payroll_id
341: and ptp.payroll_id = ptpp.payroll_id

Line 338: ,per_time_periods ptpp

334: SELECT max(ptpp.pay_advice_date)
335: INTO p_expiry_information
336: FROM pay_payroll_actions ppa
337: ,per_time_periods ptp
338: ,per_time_periods ptpp
339: WHERE ppa.payroll_action_id = p_owner_payroll_action_id
340: AND ppa.payroll_id = ptp.payroll_id
341: and ptp.payroll_id = ptpp.payroll_id
342: AND p_owner_effective_date BETWEEN ptp.start_date AND ptp.end_date

Line 414: per_time_periods

410: prd_information1, prd_information2
411: into
412: l_owner_tax_year, l_owner_tax_quarter
413: from
414: per_time_periods
415: where
416: payroll_id = l_owner_payroll_id
417: and
418: l_owner_date_earned between start_date and end_date;

Line 426: per_time_periods

422: prd_information1, prd_information2
423: into
424: l_user_tax_year, l_user_tax_quarter
425: from
426: per_time_periods
427: where
428: payroll_id = l_user_payroll_id
429: and
430: l_user_date_earned between start_date and end_date;

Line 574: per_time_periods

570: pay_advice_date
571: into
572: l_owner_month
573: from
574: per_time_periods
575: where
576: payroll_id = l_owner_payroll_id
577: and
578: l_owner_date_earned between start_date and end_date;

Line 586: per_time_periods

582: pay_advice_date
583: into
584: l_user_month
585: from
586: per_time_periods
587: where
588: payroll_id = l_user_payroll_id
589: and
590: l_user_date_earned between start_date and end_date;

Line 649: FROM per_time_periods ptp

645: */
646:
647: SELECT ptp.pay_advice_date
648: INTO p_expiry_information
649: FROM per_time_periods ptp
650: ,pay_payroll_actions ppa
651: WHERE ppa.payroll_action_id = p_owner_payroll_action_id
652: AND ppa.payroll_id = ptp.payroll_id
653: AND p_owner_effective_date BETWEEN ptp.start_date AND ptp.end_date;

Line 753: FROM per_time_periods ptp

749: ) IS
750: BEGIN
751: SELECT ptp.end_date
752: INTO p_expiry_information
753: FROM per_time_periods ptp
754: ,pay_payroll_actions ppa
755: WHERE ppa.payroll_action_id = p_owner_payroll_action_id
756: AND ppa.payroll_id = ptp.payroll_id
757: AND p_owner_effective_date BETWEEN ptp.start_date AND ptp.end_date;