[Home] [Help]
411: pel.qualifying_units
412: into l_qualifying_age,
413: l_qualifying_los,
414: l_qualifying_units
415: from pay_element_links_f pel
416: where pel.element_link_id = p_element_link_id
417: and p_session_date
418: between pel.effective_start_date
419: and pel.effective_end_date;
616: -- and the attributes of the assignment as at the effective date
617: --
618: select 'Y' ROW_RETURNED
619: from per_assignments_f ASG,
620: pay_element_links_f PEL
621: where lpi_effective_date between pel.effective_start_date
622: and pel.effective_end_date
623: and lpi_effective_date between asg.effective_start_date
624: and asg.effective_end_date
870: -- ALWAYS return a row.
871: --
872: select min (effective_start_date) LINK_START,
873: max (effective_end_date) LINK_END
874: from pay_element_links_f
875: where element_link_id = P_ELEMENT_LINK_ID;
876: --
877: cursor csr_assignment_bounds is
878: --
1182: -- Get terminaation rule for element
1183: select pet.post_termination_rule
1184: into l_post_termination_rule
1185: from pay_element_types_f pet
1186: ,pay_element_links_f pel
1187: where pel.element_link_id = p_element_link_id
1188: and l_link.link_start between pel.effective_start_date
1189: and pel.effective_end_date
1190: and pel.element_type_id = pet.element_type_id
1274: --
1275: select elt_tl.element_name
1276: from pay_element_types_f_tl ELT_TL,
1277: pay_element_types_f ELT,
1278: pay_element_links_f LINK
1279: where elt.element_type_id = link.element_type_id
1280: and elt_tl.element_type_id = elt.element_type_id
1281: and P_ELEMENT_LINK_ID = link.element_link_id
1282: and userenv('LANG') = elt_tl.language
1474: pet.processing_type
1475: into v_post_termination_rule,
1476: v_processing_type
1477: from pay_element_types_f pet,
1478: pay_element_links_f pel
1479: where p_session_date between pel.effective_start_date
1480: and pel.effective_end_date
1481: and pel.element_link_id = p_element_link_id
1482: and pet.element_type_id = pel.element_type_id
1826: select min(pel.effective_start_date),
1827: max(pel.effective_end_date)
1828: into v_element_link_start_date,
1829: v_element_link_end_date
1830: from pay_element_links_f pel
1831: where pel.element_link_id = p_element_link_id;
1832: end;
1833: --
1834: if (v_element_link_start_date > p_session_date) or
3076: --
3077: cursor c_cwk_element_check is
3078: -- Should not allow these PTO elements for CWKs
3079: select 'Y'
3080: from pay_element_links_f pel
3081: ,pay_element_types_f pet
3082: ,pay_accrual_plans pap
3083: where pel.element_link_id = p_element_link_id
3084: and p_session_date between pel.effective_start_date
3089: and pet.element_type_id = pap.accrual_plan_element_type_id
3090: union all
3091: -- Should not allow these absence elements for CWKs
3092: select 'Y'
3093: from pay_element_links_f pel
3094: ,pay_element_types_f pet
3095: ,pay_input_values_f piv
3096: ,per_absence_attendance_types abt
3097: where pel.element_link_id = p_element_link_id
3132: v_mult_entries_allowed_flag,
3133: v_third_party_pay_only_flag,
3134: v_element_name,
3135: v_classification_name
3136: from pay_element_links_f el,
3137: pay_element_types_f et,
3138: pay_element_classifications ec
3139: where el.element_link_id = p_element_link_id
3140: and et.element_type_id = el.element_type_id
3325: /*Bug 13015339 Added below code to calculate the correct validation end date for actual termination elements*/
3326: begin
3327: select distinct pet.POST_TERMINATION_RULE
3328: into v_post_termination_rule
3329: from pay_element_links_f pel,
3330: pay_element_types_f pet
3331: where pel.element_type_id=pet.element_type_id
3332: and pel.element_link_id=p_element_link_id
3333: and p_session_date between pet.effective_start_date and pet.effective_end_date
3860: v_processing_type,
3861: v_input_currency_code,
3862: v_output_currency_code
3863: from pay_element_entries_f ee,
3864: pay_element_links_f el,
3865: pay_element_types_f et
3866: where ee.element_entry_id = p_element_entry_id
3867: and el.element_link_id = ee.element_link_id
3868: and et.element_type_id = el.element_type_id