APPS.HR_CA_FF_UDFS dependencies on PAY_ELEMENT_LINKS_F

Line 2592: PAY_ELEMENT_LINKS_F ELI,

2588: --
2589: SELECT DECODE(COUNT(0), 0, 'N', 'Y')
2590: INTO v_ele_exists
2591: FROM PAY_ELEMENT_ENTRIES_F ELE,
2592: PAY_ELEMENT_LINKS_F ELI,
2593: PAY_ELEMENT_TYPES_F ELT
2594: WHERE p_date_earned
2595: BETWEEN ELE.effective_start_date
2596: AND ELE.effective_end_date

Line 2989: pay_element_links_f ELL,

2985:
2986: SELECT DECODE(COUNT(ELE.element_entry_id), 0, 'N', 'Y')
2987: INTO sepcheck_flag
2988: FROM pay_element_entries_f ELE,
2989: pay_element_links_f ELL,
2990: pay_element_types_f ELT,
2991: pay_element_classifications ECL
2992: WHERE ELE.assignment_id = p_ass_id
2993: AND p_date_earned BETWEEN

Line 3160: pay_element_links_f ELI,

3156: SELECT ELT.element_type_id,
3157: ELT.element_name,
3158: FRA.formula_name
3159: FROM pay_element_entries_f ELE,
3160: pay_element_links_f ELI,
3161: pay_element_types_f ELT,
3162: pay_status_processing_rules_f SPR,
3163: ff_formulas_f FRA
3164: WHERE FRA.formula_id = SPR.formula_id

Line 3193: FROM pay_element_links_f pel,

3189: to improve performance.
3190: */
3191: CURSOR get_flat_amounts IS
3192: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3193: FROM pay_element_links_f pel,
3194: pay_element_entries_f ele,
3195: pay_element_entry_values_f eev,
3196: pay_input_values_f ipv
3197: WHERE pel.element_type_id = v_eletype_id

Line 3212: FROM pay_element_links_f pel,

3208: --
3209: CURSOR get_rates IS
3210: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value),
3211: EEV.element_entry_id
3212: FROM pay_element_links_f pel,
3213: pay_element_entries_f ele,
3214: pay_element_entry_values_f eev,
3215: pay_input_values_f ipv
3216: WHERE pel.element_type_id = v_eletype_id

Line 3230: FROM pay_element_links_f pel,

3226: AND IPV.name = 'Rate';
3227: --
3228: CURSOR get_percentages 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 4344: ,pay_element_links_f pel

4340: SELECT peev.screen_entry_value
4341: ,piv.name
4342: FROM pay_element_entry_values_f peev
4343: ,pay_element_entries_f pee
4344: ,pay_element_links_f pel
4345: ,pay_element_types_f pet
4346: ,pay_input_values_f piv
4347: ,per_pay_bases ppb
4348: ,per_all_assignments_f paa