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

Line 844: from PER_TIME_PERIODS

840: END IF;
841:
842: Select COUNT(*)
843: INTO l_num_of_periods
844: from PER_TIME_PERIODS
845: where PAYROLL_ID=p_payroll_id
846: and REGULAR_PAYMENT_DATE <> p_start_date
847: and REGULAR_PAYMENT_DATE between l_start_date and p_end_date
848: and REGULAR_PAYMENT_DATE <= to_date('31-12-' || to_char(p_curr_pay_start_date,'RRRR'),'DD-MM-RRRR');

Line 884: from PER_TIME_PERIODS

880: BEGIN
881:
882: Select COUNT(*)
883: INTO l_num_of_periods
884: from PER_TIME_PERIODS
885: where PAYROLL_ID=p_payroll_id
886: and to_char(REGULAR_PAYMENT_DATE,'mm-yyyy') = to_char(p_curr_per_pay_date,'mm-yyyy');
887:
888: EXCEPTION

Line 915: from PER_TIME_PERIODS

911: BEGIN
912:
913: Select REGULAR_PAYMENT_DATE
914: INTO l_regular_pay_date
915: from PER_TIME_PERIODS
916: where PAYROLL_ID=p_payroll_id
917: and START_DATE = p_Curr_Pay_Start_Date;
918:
919: EXCEPTION