APPS.HR_US_FF_UDFS dependencies on PAY_ELEMENT_LINKS_F

Line 3002: PAY_ELEMENT_LINKS_F ELI,

2998:
2999: SELECT DECODE(COUNT(0), 0, 'N', 'Y')
3000: INTO v_ele_exists
3001: FROM PAY_ELEMENT_ENTRIES_F ELE,
3002: PAY_ELEMENT_LINKS_F ELI,
3003: PAY_ELEMENT_TYPES_F ELT
3004: WHERE p_date_earned BETWEEN ELE.effective_start_date
3005: AND ELE.effective_end_date
3006: AND ELE.assignment_id = p_asst_id

Line 3334: pay_element_links_f ELL,

3330:
3331: SELECT DECODE(COUNT(ELE.element_entry_id), 0, 'N', 'Y')
3332: INTO sepcheck_flag
3333: FROM pay_element_entries_f ELE,
3334: pay_element_links_f ELL,
3335: pay_element_types_f ELT,
3336: pay_element_classifications ECL
3337: WHERE ELE.assignment_id = p_ass_id
3338: AND p_date_earned BETWEEN ELE.effective_start_date

Line 3525: pay_element_links_f ELI,

3521: SELECT ELT.element_type_id,
3522: ELT.element_name,
3523: FRA.formula_name
3524: FROM pay_element_entries_f ELE,
3525: pay_element_links_f ELI,
3526: pay_element_types_f ELT,
3527: pay_status_processing_rules_f SPR,
3528: ff_formulas_f FRA
3529: WHERE FRA.formula_id = SPR.formula_id

Line 3551: FROM pay_element_links_f pel,

3547: -- These cursors get ALL entries of a particular element type during
3548: -- the period:
3549: CURSOR get_flat_amounts IS
3550: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3551: FROM pay_element_links_f pel,
3552: pay_element_entries_f ele,
3553: pay_element_entry_values_f eev,
3554: pay_input_values_f ipv
3555: WHERE pel.element_type_id = v_eletype_id

Line 3570: FROM pay_element_links_f pel,

3566: --
3567: CURSOR get_rates IS
3568: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value),
3569: EEV.element_entry_id
3570: FROM pay_element_links_f pel,
3571: pay_element_entries_f ele,
3572: pay_element_entry_values_f eev,
3573: pay_input_values_f ipv
3574: WHERE pel.element_type_id = v_eletype_id

Line 3588: FROM pay_element_links_f pel,

3584: AND IPV.name = 'Rate';
3585: --
3586: CURSOR get_percentages IS
3587: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3588: FROM pay_element_links_f pel,
3589: pay_element_entries_f ele,
3590: pay_element_entry_values_f eev,
3591: pay_input_values_f ipv
3592: WHERE pel.element_type_id = v_eletype_id