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 1537: p_earnings_category IN hxt_add_elem_info_f.earning_category%TYPE,

1533: END element_linked;
1534:
1535: FUNCTION valid_for_summing (
1536: p_element_id IN pay_element_types_f.element_type_id%TYPE,
1537: p_earnings_category IN hxt_add_elem_info_f.earning_category%TYPE,
1538: p_day IN DATE,
1539: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1540: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
1541: p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE

Line 1541: p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE

1537: p_earnings_category IN hxt_add_elem_info_f.earning_category%TYPE,
1538: p_day IN DATE,
1539: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1540: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
1541: p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE
1542: DEFAULT NULL,
1543: p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE
1544: DEFAULT NULL,
1545: p_valid_earn_cat3 IN hxt_add_elem_info_f.earning_category%TYPE

Line 1543: p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE

1539: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1540: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
1541: p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE
1542: DEFAULT NULL,
1543: p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE
1544: DEFAULT NULL,
1545: p_valid_earn_cat3 IN hxt_add_elem_info_f.earning_category%TYPE
1546: DEFAULT NULL,
1547: p_valid_earn_cat4 IN hxt_add_elem_info_f.earning_category%TYPE

Line 1545: p_valid_earn_cat3 IN hxt_add_elem_info_f.earning_category%TYPE

1541: p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE
1542: DEFAULT NULL,
1543: p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE
1544: DEFAULT NULL,
1545: p_valid_earn_cat3 IN hxt_add_elem_info_f.earning_category%TYPE
1546: DEFAULT NULL,
1547: p_valid_earn_cat4 IN hxt_add_elem_info_f.earning_category%TYPE
1548: DEFAULT NULL,
1549: p_valid_earn_cat5 IN hxt_add_elem_info_f.earning_category%TYPE

Line 1547: p_valid_earn_cat4 IN hxt_add_elem_info_f.earning_category%TYPE

1543: p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE
1544: DEFAULT NULL,
1545: p_valid_earn_cat3 IN hxt_add_elem_info_f.earning_category%TYPE
1546: DEFAULT NULL,
1547: p_valid_earn_cat4 IN hxt_add_elem_info_f.earning_category%TYPE
1548: DEFAULT NULL,
1549: p_valid_earn_cat5 IN hxt_add_elem_info_f.earning_category%TYPE
1550: DEFAULT NULL,
1551: p_valid_earn_cat6 IN hxt_add_elem_info_f.earning_category%TYPE

Line 1549: p_valid_earn_cat5 IN hxt_add_elem_info_f.earning_category%TYPE

1545: p_valid_earn_cat3 IN hxt_add_elem_info_f.earning_category%TYPE
1546: DEFAULT NULL,
1547: p_valid_earn_cat4 IN hxt_add_elem_info_f.earning_category%TYPE
1548: DEFAULT NULL,
1549: p_valid_earn_cat5 IN hxt_add_elem_info_f.earning_category%TYPE
1550: DEFAULT NULL,
1551: p_valid_earn_cat6 IN hxt_add_elem_info_f.earning_category%TYPE
1552: DEFAULT NULL,
1553: p_valid_earn_cat7 IN hxt_add_elem_info_f.earning_category%TYPE

Line 1551: p_valid_earn_cat6 IN hxt_add_elem_info_f.earning_category%TYPE

1547: p_valid_earn_cat4 IN hxt_add_elem_info_f.earning_category%TYPE
1548: DEFAULT NULL,
1549: p_valid_earn_cat5 IN hxt_add_elem_info_f.earning_category%TYPE
1550: DEFAULT NULL,
1551: p_valid_earn_cat6 IN hxt_add_elem_info_f.earning_category%TYPE
1552: DEFAULT NULL,
1553: p_valid_earn_cat7 IN hxt_add_elem_info_f.earning_category%TYPE
1554: DEFAULT NULL
1555: )

Line 1553: p_valid_earn_cat7 IN hxt_add_elem_info_f.earning_category%TYPE

1549: p_valid_earn_cat5 IN hxt_add_elem_info_f.earning_category%TYPE
1550: DEFAULT NULL,
1551: p_valid_earn_cat6 IN hxt_add_elem_info_f.earning_category%TYPE
1552: DEFAULT NULL,
1553: p_valid_earn_cat7 IN hxt_add_elem_info_f.earning_category%TYPE
1554: DEFAULT NULL
1555: )
1556: RETURN BOOLEAN
1557: IS

Line 1625: FROM hxt_det_hours_worked_x hdhwx, hxt_add_elem_info_f haeif

1621: )
1622: IS
1623: SELECT SUM (hdhwx.hours) hours, hdhwx.element_type_id,
1624: haeif.earning_category
1625: FROM hxt_det_hours_worked_x hdhwx, hxt_add_elem_info_f haeif
1626: WHERE hdhwx.tim_id = p_tim_id
1627: AND hdhwx.date_worked = p_date_worked
1628: AND hdhwx.element_type_id = haeif.element_type_id
1629: AND hdhwx.date_worked BETWEEN haeif.effective_start_date