APPS.HR_CA_FF_UDFS dependencies on PAY_ELEMENT_LINKS_F

Line 2629: PAY_ELEMENT_LINKS_F ELI,

2625: --
2626: SELECT DECODE(COUNT(0), 0, 'N', 'Y')
2627: INTO v_ele_exists
2628: FROM PAY_ELEMENT_ENTRIES_F ELE,
2629: PAY_ELEMENT_LINKS_F ELI,
2630: PAY_ELEMENT_TYPES_F ELT
2631: WHERE p_date_earned
2632: BETWEEN ELE.effective_start_date
2633: AND ELE.effective_end_date

Line 3026: pay_element_links_f ELL,

3022:
3023: SELECT DECODE(COUNT(ELE.element_entry_id), 0, 'N', 'Y')
3024: INTO sepcheck_flag
3025: FROM pay_element_entries_f ELE,
3026: pay_element_links_f ELL,
3027: pay_element_types_f ELT,
3028: pay_element_classifications ECL
3029: WHERE ELE.assignment_id = p_ass_id
3030: AND p_date_earned BETWEEN

Line 3197: pay_element_links_f ELI,

3193: SELECT ELT.element_type_id,
3194: ELT.element_name,
3195: FRA.formula_name
3196: FROM pay_element_entries_f ELE,
3197: pay_element_links_f ELI,
3198: pay_element_types_f ELT,
3199: pay_status_processing_rules_f SPR,
3200: ff_formulas_f FRA
3201: WHERE FRA.formula_id = SPR.formula_id

Line 3230: FROM pay_element_links_f pel,

3226: to improve performance.
3227: */
3228: CURSOR get_flat_amounts IS
3229: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3230: FROM pay_element_links_f pel,
3231: pay_element_entries_f ele,
3232: pay_element_entry_values_f eev,
3233: pay_input_values_f ipv
3234: WHERE pel.element_type_id = v_eletype_id

Line 3249: FROM pay_element_links_f pel,

3245: --
3246: CURSOR get_rates IS
3247: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value),
3248: EEV.element_entry_id
3249: FROM pay_element_links_f pel,
3250: pay_element_entries_f ele,
3251: pay_element_entry_values_f eev,
3252: pay_input_values_f ipv
3253: WHERE pel.element_type_id = v_eletype_id

Line 3267: FROM pay_element_links_f pel,

3263: AND IPV.name = 'Rate';
3264: --
3265: CURSOR get_percentages IS
3266: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3267: FROM pay_element_links_f pel,
3268: pay_element_entries_f ele,
3269: pay_element_entry_values_f eev,
3270: pay_input_values_f ipv
3271: WHERE pel.element_type_id = v_eletype_id

Line 4381: ,pay_element_links_f pel

4377: SELECT peev.screen_entry_value
4378: ,piv.name
4379: FROM pay_element_entry_values_f peev
4380: ,pay_element_entries_f pee
4381: ,pay_element_links_f pel
4382: ,pay_element_types_f pet
4383: ,pay_input_values_f piv
4384: ,per_pay_bases ppb
4385: ,per_all_assignments_f paa