APPS.HXT_TIMECARD_API dependencies on HXT_SUM_HOURS_WORKED

Line 298: ,hxt_sum_hours_worked sm

294: ,pay_element_types_f elt
295: ,PAY_ACCRUAL_PLANS pap
296: ,PAY_NET_CALCULATION_RULES net
297: ,PAY_INPUT_VALUES_F piv
298: ,hxt_sum_hours_worked sm
299: ,per_assignments_f asm
300: WHERE elt.element_type_id = eltv.element_type_id
301: AND eltv.hxt_earning_category = 'ABS'
302: AND sm.date_worked BETWEEN ELT.EFFECTIVE_START_DATE

Line 334: CURSOR accrual_cur(p_date_worked hxt_sum_hours_worked.date_worked%TYPE) IS

330: AND PEEF.EFFECTIVE_END_DATE
331: AND PETF1.ELEMENT_TYPE_ID = PAP1.ACCRUAL_PLAN_ELEMENT_TYPE_ID);
332: -- End ER180
333:
334: CURSOR accrual_cur(p_date_worked hxt_sum_hours_worked.date_worked%TYPE) IS
335: SELECT distinct pap.accrual_plan_name
336: FROM hxt_pay_element_types_f_ddf_v eltv
337: ,pay_element_types_f elt
338: ,PAY_ACCRUAL_PLANS pap

Line 341: ,hxt_sum_hours_worked sm

337: ,pay_element_types_f elt
338: ,PAY_ACCRUAL_PLANS pap
339: ,PAY_NET_CALCULATION_RULES net
340: ,PAY_INPUT_VALUES_F piv
341: ,hxt_sum_hours_worked sm
342: ,per_assignments_f asm
343: ,per_people_f ppl -- ER180 Bug Fix
344: WHERE elt.element_type_id = eltv.element_type_id
345: AND eltv.hxt_earning_category = 'ABS'

Line 391: ,hxt_sum_hours_worked sm

387: ,pay_element_types_f elt
388: ,PAY_ACCRUAL_PLANS pap
389: ,PAY_NET_CALCULATION_RULES net
390: ,PAY_INPUT_VALUES_F piv
391: ,hxt_sum_hours_worked sm
392: ,per_assignments_f asm
393: WHERE elt.element_type_id = eltv.element_type_id
394: AND eltv.hxt_earning_category = 'ABS'
395: AND net.ACCRUAL_PLAN_ID = pap.ACCRUAL_PLAN_ID