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 539: hxt_pay_element_types_f_ddf_v elem

535: p_date IN DATE)
536: IS SELECT DISTINCT
537: er.element_type_id
538: FROM hxt_earning_rules er,
539: hxt_pay_element_types_f_ddf_v elem
540: WHERE er.egp_id = p_ep_id
541: AND p_date BETWEEN er.effective_start_date
542: AND er.effective_end_date
543: AND g_sum_session_date BETWEEN er.effective_start_date

Line 580: hxt_pay_element_types_f_ddf_v elem

576: SELECT NVL(SUM(det.hours),0)
577: FROM hxt_det_hours_worked_f det,
578: hxt_sum_hours_worked_f sum,
579: hxt_earning_rules er,
580: hxt_pay_element_types_f_ddf_v elem
581: WHERE det.tim_id = g_hol_tim_id
582: AND sum.id = det.parent_id
583: AND g_sum_session_date BETWEEN sum.effective_start_date
584: AND sum.effective_end_date

Line 1383: l_rate_multiple HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;

1379: l_pa_status VARCHAR2(1);
1380: l_retro_batch_id NUMBER(15);
1381: l_error_status NUMBER(15);
1382: l_sqlerrm VARCHAR2(200);
1383: l_rate_multiple HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
1384: l_hourly_rate HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
1385: l_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
1386: l_hours HXT_DET_HOURS_WORKED_F.HOURS%TYPE; -- SIR092
1387: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;

Line 1384: l_hourly_rate HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;

1380: l_retro_batch_id NUMBER(15);
1381: l_error_status NUMBER(15);
1382: l_sqlerrm VARCHAR2(200);
1383: l_rate_multiple HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
1384: l_hourly_rate HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
1385: l_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
1386: l_hours HXT_DET_HOURS_WORKED_F.HOURS%TYPE; -- SIR092
1387: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;
1388: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;

Line 1385: l_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;

1381: l_error_status NUMBER(15);
1382: l_sqlerrm VARCHAR2(200);
1383: l_rate_multiple HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
1384: l_hourly_rate HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
1385: l_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
1386: l_hours HXT_DET_HOURS_WORKED_F.HOURS%TYPE; -- SIR092
1387: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;
1388: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;
1389: l_premium_type HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_TYPE%TYPE;

Line 1389: l_premium_type HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_TYPE%TYPE;

1385: l_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
1386: l_hours HXT_DET_HOURS_WORKED_F.HOURS%TYPE; -- SIR092
1387: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;
1388: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;
1389: l_premium_type HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_TYPE%TYPE;
1390: l_premium_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
1391: l_processing_order HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PROCESSING_ORDER%TYPE;
1392:
1393: CURSOR next_id_cur IS

Line 1390: l_premium_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;

1386: l_hours HXT_DET_HOURS_WORKED_F.HOURS%TYPE; -- SIR092
1387: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;
1388: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;
1389: l_premium_type HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_TYPE%TYPE;
1390: l_premium_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
1391: l_processing_order HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PROCESSING_ORDER%TYPE;
1392:
1393: CURSOR next_id_cur IS
1394: SELECT hxt_seqno.nextval next_id

Line 1391: l_processing_order HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PROCESSING_ORDER%TYPE;

1387: l_costable_type PAY_ELEMENT_LINKS_F.COSTABLE_TYPE%TYPE;
1388: l_ffv_cost_center_id HXT_DET_HOURS_WORKED_F.FFV_COST_CENTER_ID%TYPE;
1389: l_premium_type HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_TYPE%TYPE;
1390: l_premium_amount HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PREMIUM_AMOUNT%TYPE;
1391: l_processing_order HXT_PAY_ELEMENT_TYPES_F_DDF_V.HXT_PROCESSING_ORDER%TYPE;
1392:
1393: CURSOR next_id_cur IS
1394: SELECT hxt_seqno.nextval next_id
1395: FROM dual;

Line 1401: FROM hxt_pay_element_types_f_ddf_v eltv

1397: CURSOR get_ovt_rates_cur IS
1398: SELECT eltv.hxt_premium_type,
1399: eltv.hxt_premium_amount,
1400: eltv.hxt_processing_order
1401: FROM hxt_pay_element_types_f_ddf_v eltv
1402: WHERE eltv.hxt_earning_category NOT IN ('REG', 'ABS')
1403: AND g_DATE_WORKED between eltv.effective_start_date
1404: and eltv.effective_end_date
1405: AND eltv.element_type_id = g_element_type_id