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_BATCH_VAL dependencies on HXT_ADD_ELEM_INFO_F

Line 1357: p_earnings_category IN hxt_add_elem_info_f.earning_category%TYPE,

1353: END element_linked;
1354:
1355: FUNCTION valid_for_summing (
1356: p_element_id IN pay_element_types_f.element_type_id%TYPE,
1357: p_earnings_category IN hxt_add_elem_info_f.earning_category%TYPE,
1358: p_day IN DATE,
1359: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1360: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
1361: p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE

Line 1361: p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE

1357: p_earnings_category IN hxt_add_elem_info_f.earning_category%TYPE,
1358: p_day IN DATE,
1359: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1360: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
1361: p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE
1362: DEFAULT NULL,
1363: p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE
1364: DEFAULT NULL,
1365: p_valid_earn_cat3 IN hxt_add_elem_info_f.earning_category%TYPE

Line 1363: p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE

1359: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1360: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
1361: p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE
1362: DEFAULT NULL,
1363: p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE
1364: DEFAULT NULL,
1365: p_valid_earn_cat3 IN hxt_add_elem_info_f.earning_category%TYPE
1366: DEFAULT NULL,
1367: p_valid_earn_cat4 IN hxt_add_elem_info_f.earning_category%TYPE

Line 1365: p_valid_earn_cat3 IN hxt_add_elem_info_f.earning_category%TYPE

1361: p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE
1362: DEFAULT NULL,
1363: p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE
1364: DEFAULT NULL,
1365: p_valid_earn_cat3 IN hxt_add_elem_info_f.earning_category%TYPE
1366: DEFAULT NULL,
1367: p_valid_earn_cat4 IN hxt_add_elem_info_f.earning_category%TYPE
1368: DEFAULT NULL,
1369: p_valid_earn_cat5 IN hxt_add_elem_info_f.earning_category%TYPE

Line 1367: p_valid_earn_cat4 IN hxt_add_elem_info_f.earning_category%TYPE

1363: p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE
1364: DEFAULT NULL,
1365: p_valid_earn_cat3 IN hxt_add_elem_info_f.earning_category%TYPE
1366: DEFAULT NULL,
1367: p_valid_earn_cat4 IN hxt_add_elem_info_f.earning_category%TYPE
1368: DEFAULT NULL,
1369: p_valid_earn_cat5 IN hxt_add_elem_info_f.earning_category%TYPE
1370: DEFAULT NULL,
1371: p_valid_earn_cat6 IN hxt_add_elem_info_f.earning_category%TYPE

Line 1369: p_valid_earn_cat5 IN hxt_add_elem_info_f.earning_category%TYPE

1365: p_valid_earn_cat3 IN hxt_add_elem_info_f.earning_category%TYPE
1366: DEFAULT NULL,
1367: p_valid_earn_cat4 IN hxt_add_elem_info_f.earning_category%TYPE
1368: DEFAULT NULL,
1369: p_valid_earn_cat5 IN hxt_add_elem_info_f.earning_category%TYPE
1370: DEFAULT NULL,
1371: p_valid_earn_cat6 IN hxt_add_elem_info_f.earning_category%TYPE
1372: DEFAULT NULL,
1373: p_valid_earn_cat7 IN hxt_add_elem_info_f.earning_category%TYPE

Line 1371: p_valid_earn_cat6 IN hxt_add_elem_info_f.earning_category%TYPE

1367: p_valid_earn_cat4 IN hxt_add_elem_info_f.earning_category%TYPE
1368: DEFAULT NULL,
1369: p_valid_earn_cat5 IN hxt_add_elem_info_f.earning_category%TYPE
1370: DEFAULT NULL,
1371: p_valid_earn_cat6 IN hxt_add_elem_info_f.earning_category%TYPE
1372: DEFAULT NULL,
1373: p_valid_earn_cat7 IN hxt_add_elem_info_f.earning_category%TYPE
1374: DEFAULT NULL
1375: )

Line 1373: p_valid_earn_cat7 IN hxt_add_elem_info_f.earning_category%TYPE

1369: p_valid_earn_cat5 IN hxt_add_elem_info_f.earning_category%TYPE
1370: DEFAULT NULL,
1371: p_valid_earn_cat6 IN hxt_add_elem_info_f.earning_category%TYPE
1372: DEFAULT NULL,
1373: p_valid_earn_cat7 IN hxt_add_elem_info_f.earning_category%TYPE
1374: DEFAULT NULL
1375: )
1376: RETURN BOOLEAN
1377: IS

Line 1445: FROM hxt_det_hours_worked_x hdhwx, hxt_add_elem_info_f haeif

1441: )
1442: IS
1443: SELECT SUM (hdhwx.hours) hours, hdhwx.element_type_id,
1444: haeif.earning_category
1445: FROM hxt_det_hours_worked_x hdhwx, hxt_add_elem_info_f haeif
1446: WHERE hdhwx.tim_id = p_tim_id
1447: AND hdhwx.date_worked = p_date_worked
1448: AND hdhwx.element_type_id = haeif.element_type_id
1449: AND hdhwx.date_worked BETWEEN haeif.effective_start_date