DBA Data[Home] [Help]

APPS.HXT_UTIL dependencies on PAY_ELEMENT_LINKS_F

Line 1599: PAY_ELEMENT_LINKS_F PELF,

1595: FROM
1596: PAY_ELEMENT_TYPES_F PETF,
1597: PAY_ELEMENT_CLASSIFICATIONS PEC,
1598: PAY_ELEMENT_ENTRIES_F PEEF,
1599: PAY_ELEMENT_LINKS_F PELF,
1600: PAY_ACCRUAL_PLANS PAP
1601: WHERE
1602: PEEF.ASSIGNMENT_ID=P_assignment_id
1603: AND PETF.CLASSIFICATION_ID=PEC.CLASSIFICATION_ID

Line 1941: FROM pay_element_links_f pel,

1937: p_assignment_id IN NUMBER) return VARCHAR2 IS
1938:
1939: CURSOR cur_costable_type IS
1940: SELECT pel.costable_type
1941: FROM pay_element_links_f pel,
1942: per_assignments_f asm
1943: WHERE asm.assignment_id = p_assignment_id
1944: AND p_date_worked BETWEEN asm.effective_start_date
1945: AND asm.effective_end_date