APPS.HR_ENTRY dependencies on PAY_ELEMENT_LINKS_F

Line 378: from pay_element_links_f pel

374: pel.qualifying_units
375: into l_qualifying_age,
376: l_qualifying_los,
377: l_qualifying_units
378: from pay_element_links_f pel
379: where pel.element_link_id = p_element_link_id
380: and p_session_date
381: between pel.effective_start_date
382: and pel.effective_end_date;

Line 576: pay_element_links_f PEL

572: -- and the attributes of the assignment as at the effective date
573: --
574: select 'Y' ROW_RETURNED
575: from per_assignments_f ASG,
576: pay_element_links_f PEL
577: where lpi_effective_date between pel.effective_start_date
578: and pel.effective_end_date
579: and lpi_effective_date between asg.effective_start_date
580: and asg.effective_end_date

Line 778: from pay_element_links_f

774: -- ALWAYS return a row.
775: --
776: select min (effective_start_date) LINK_START,
777: max (effective_end_date) LINK_END
778: from pay_element_links_f
779: where element_link_id = P_ELEMENT_LINK_ID;
780: --
781: cursor csr_assignment_bounds is
782: --

Line 1087: pay_element_links_f LINK

1083: --
1084: select elt_tl.element_name
1085: from pay_element_types_f_tl ELT_TL,
1086: pay_element_types_f ELT,
1087: pay_element_links_f LINK
1088: where elt.element_type_id = link.element_type_id
1089: and elt_tl.element_type_id = elt.element_type_id
1090: and P_ELEMENT_LINK_ID = link.element_link_id
1091: and userenv('LANG') = elt_tl.language

Line 1278: pay_element_links_f pel

1274: pet.processing_type
1275: into v_post_termination_rule,
1276: v_processing_type
1277: from pay_element_types_f pet,
1278: pay_element_links_f pel
1279: where p_session_date between pel.effective_start_date
1280: and pel.effective_end_date
1281: and pel.element_link_id = p_element_link_id
1282: and pet.element_type_id = pel.element_type_id

Line 1618: from pay_element_links_f pel

1614: select min(pel.effective_start_date),
1615: max(pel.effective_end_date)
1616: into v_element_link_start_date,
1617: v_element_link_end_date
1618: from pay_element_links_f pel
1619: where pel.element_link_id = p_element_link_id;
1620: end;
1621: --
1622: if (v_element_link_start_date > p_session_date) or

Line 2804: from pay_element_links_f pel

2800: --
2801: cursor c_cwk_element_check is
2802: -- Should not allow these PTO elements for CWKs
2803: select 'Y'
2804: from pay_element_links_f pel
2805: ,pay_element_types_f pet
2806: ,pay_accrual_plans pap
2807: where pel.element_link_id = p_element_link_id
2808: and p_session_date between pel.effective_start_date

Line 2817: from pay_element_links_f pel

2813: and pet.element_type_id = pap.accrual_plan_element_type_id
2814: union all
2815: -- Should not allow these absence elements for CWKs
2816: select 'Y'
2817: from pay_element_links_f pel
2818: ,pay_element_types_f pet
2819: ,pay_input_values_f piv
2820: ,per_absence_attendance_types abt
2821: where pel.element_link_id = p_element_link_id

Line 2860: from pay_element_links_f el,

2856: v_mult_entries_allowed_flag,
2857: v_third_party_pay_only_flag,
2858: v_element_name,
2859: v_classification_name
2860: from pay_element_links_f el,
2861: pay_element_types_f et,
2862: pay_element_classifications ec
2863: where el.element_link_id = p_element_link_id
2864: and et.element_type_id = el.element_type_id

Line 3488: pay_element_links_f el,

3484: v_processing_type,
3485: v_input_currency_code,
3486: v_output_currency_code
3487: from pay_element_entries_f ee,
3488: pay_element_links_f el,
3489: pay_element_types_f et
3490: where ee.element_entry_id = p_element_entry_id
3491: and el.element_link_id = ee.element_link_id
3492: and et.element_type_id = el.element_type_id