APPS.HR_US_FF_UDFS dependencies on PAY_ELEMENT_LINKS_F

Line 3011: PAY_ELEMENT_LINKS_F ELI,

3007:
3008: SELECT DECODE(COUNT(0), 0, 'N', 'Y')
3009: INTO v_ele_exists
3010: FROM PAY_ELEMENT_ENTRIES_F ELE,
3011: PAY_ELEMENT_LINKS_F ELI,
3012: PAY_ELEMENT_TYPES_F ELT
3013: WHERE p_date_earned BETWEEN ELE.effective_start_date
3014: AND ELE.effective_end_date
3015: AND ELE.assignment_id = p_asst_id

Line 3343: pay_element_links_f ELL,

3339:
3340: SELECT DECODE(COUNT(ELE.element_entry_id), 0, 'N', 'Y')
3341: INTO sepcheck_flag
3342: FROM pay_element_entries_f ELE,
3343: pay_element_links_f ELL,
3344: pay_element_types_f ELT,
3345: pay_element_classifications ECL
3346: WHERE ELE.assignment_id = p_ass_id
3347: AND p_date_earned BETWEEN ELE.effective_start_date

Line 3534: pay_element_links_f ELI,

3530: SELECT ELT.element_type_id,
3531: ELT.element_name,
3532: FRA.formula_name
3533: FROM pay_element_entries_f ELE,
3534: pay_element_links_f ELI,
3535: pay_element_types_f ELT,
3536: pay_status_processing_rules_f SPR,
3537: ff_formulas_f FRA
3538: WHERE FRA.formula_id = SPR.formula_id

Line 3560: FROM pay_element_links_f pel,

3556: -- These cursors get ALL entries of a particular element type during
3557: -- the period:
3558: CURSOR get_flat_amounts IS
3559: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3560: FROM pay_element_links_f pel,
3561: pay_element_entries_f ele,
3562: pay_element_entry_values_f eev,
3563: pay_input_values_f ipv
3564: WHERE pel.element_type_id = v_eletype_id

Line 3579: FROM pay_element_links_f pel,

3575: --
3576: CURSOR get_rates IS
3577: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value),
3578: EEV.element_entry_id
3579: FROM pay_element_links_f pel,
3580: pay_element_entries_f ele,
3581: pay_element_entry_values_f eev,
3582: pay_input_values_f ipv
3583: WHERE pel.element_type_id = v_eletype_id

Line 3597: FROM pay_element_links_f pel,

3593: AND IPV.name = 'Rate';
3594: --
3595: CURSOR get_percentages IS
3596: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3597: FROM pay_element_links_f pel,
3598: pay_element_entries_f ele,
3599: pay_element_entry_values_f eev,
3600: pay_input_values_f ipv
3601: WHERE pel.element_type_id = v_eletype_id