DBA Data[Home] [Help]

APPS.HXT_UTIL dependencies on PAY_ELEMENT_LINKS_F

Line 1620: PAY_ELEMENT_LINKS_F PELF,

1616: FROM
1617: PAY_ELEMENT_TYPES_F PETF,
1618: PAY_ELEMENT_CLASSIFICATIONS PEC,
1619: PAY_ELEMENT_ENTRIES_F PEEF,
1620: PAY_ELEMENT_LINKS_F PELF,
1621: PAY_ACCRUAL_PLANS PAP
1622: WHERE
1623: PEEF.ASSIGNMENT_ID=P_assignment_id
1624: AND PETF.CLASSIFICATION_ID=PEC.CLASSIFICATION_ID

Line 1758: pay_element_links_f pel,

1754: pap.accrual_plan_name,
1755: pap.accrual_category,
1756: pap.business_group_id
1757: FROM pay_element_entries_f pee,
1758: pay_element_links_f pel,
1759: pay_element_types_f pet,
1760: pay_accrual_plans pap
1761: WHERE pee.assignment_id = p_assignment_id
1762: AND p_calculation_date BETWEEN pee.effective_start_date

Line 2011: FROM pay_element_links_f pel,

2007: p_assignment_id IN NUMBER) return VARCHAR2 IS
2008:
2009: CURSOR cur_costable_type IS
2010: SELECT pel.costable_type
2011: FROM pay_element_links_f pel,
2012: per_assignments_f asm
2013: WHERE asm.assignment_id = p_assignment_id
2014: AND p_date_worked BETWEEN asm.effective_start_date
2015: AND asm.effective_end_date