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.HXT_TIME_SUMMARY dependencies on HXT_PAY_ELEMENT_TYPES_F_DDF_V

Line 215: l_rate_multiple HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;

211: l_pa_status VARCHAR2(1);
212: l_retro_batch_id NUMBER(15);
213: l_error_status NUMBER(15);
214: l_sqlerrm VARCHAR2(200);
215: l_rate_multiple HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
216: l_hourly_rate HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
217: l_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
218: l_hours HXT_DET_HOURS_WORKED_F.HOURS%TYPE; -- SIR092
219: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;

Line 216: l_hourly_rate HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;

212: l_retro_batch_id NUMBER(15);
213: l_error_status NUMBER(15);
214: l_sqlerrm VARCHAR2(200);
215: l_rate_multiple HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
216: l_hourly_rate HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
217: l_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
218: l_hours HXT_DET_HOURS_WORKED_F.HOURS%TYPE; -- SIR092
219: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;
220: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;

Line 217: l_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;

213: l_error_status NUMBER(15);
214: l_sqlerrm VARCHAR2(200);
215: l_rate_multiple HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
216: l_hourly_rate HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
217: l_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
218: l_hours HXT_DET_HOURS_WORKED_F.HOURS%TYPE; -- SIR092
219: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;
220: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;
221: l_premium_type HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_TYPE%TYPE;

Line 221: l_premium_type HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_TYPE%TYPE;

217: l_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
218: l_hours HXT_DET_HOURS_WORKED_F.HOURS%TYPE; -- SIR092
219: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;
220: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;
221: l_premium_type HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_TYPE%TYPE;
222: l_premium_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
223: l_processing_order HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PROCESSING_ORDER%TYPE;
224:
225: CURSOR next_id_cur IS

Line 222: l_premium_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;

218: l_hours HXT_DET_HOURS_WORKED_F.HOURS%TYPE; -- SIR092
219: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;
220: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;
221: l_premium_type HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_TYPE%TYPE;
222: l_premium_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
223: l_processing_order HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PROCESSING_ORDER%TYPE;
224:
225: CURSOR next_id_cur IS
226: SELECT hxt_seqno.nextval next_id

Line 223: l_processing_order HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PROCESSING_ORDER%TYPE;

219: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;
220: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;
221: l_premium_type HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_TYPE%TYPE;
222: l_premium_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
223: l_processing_order HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PROCESSING_ORDER%TYPE;
224:
225: CURSOR next_id_cur IS
226: SELECT hxt_seqno.nextval next_id
227: FROM dual;

Line 233: FROM hxt_pay_element_types_f_ddf_v eltv

229: CURSOR get_ovt_rates_cur IS
230: SELECT eltv.hxt_premium_type,
231: eltv.hxt_premium_amount,
232: eltv.hxt_processing_order
233: FROM hxt_pay_element_types_f_ddf_v eltv
234: WHERE eltv.hxt_earning_category NOT IN ('REG', 'ABS')
235: AND g_DATE_WORKED between eltv.effective_start_date
236: and eltv.effective_end_date
237: AND eltv.element_type_id = g_element_type_id