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

Line 879: l_value PER_TIME_PERIODS.PRD_INFORMATION2%TYPE;

875: /* Added to support override for Use of Holiday Card for transfer to Holiday Bank for bug fix 5533140*/
876: FUNCTION get_use_hol_card(p_payroll_action_id NUMBER,p_date_earned DATE ) RETURN VARCHAR2
877: IS
878:
879: l_value PER_TIME_PERIODS.PRD_INFORMATION2%TYPE;
880: l_payroll_id NUMBER;
881:
882: /* Modified the cursor for bug 5533140*/
883:

Line 917: , per_time_periods TPERIOD

913: Select
914: TPTYPE.number_per_fiscal_year
915: from
916: pay_payroll_actions PACTION
917: , per_time_periods TPERIOD
918: , per_time_period_types TPTYPE
919: where PACTION.payroll_action_id = p_payroll_action_id
920: and TPERIOD.payroll_id = PACTION.payroll_id
921: and p_date_earned between TPERIOD.start_date and TPERIOD.end_date