APPS.PQP_GB_OSP_FUNCTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 603: FROM pay_element_types_f pet

599: ) IS
600: SELECT piv.display_sequence
601: ,pet.element_type_id
602: ,piv.input_value_id id
603: FROM pay_element_types_f pet
604: ,pay_input_values_f piv
605: WHERE pet.element_type_id = p_element_type_id
606: AND p_effective_date
607: BETWEEN pet.effective_start_date

Line 621: (p_element_name IN pay_element_types_f.element_name%TYPE

617: INDEX BY BINARY_INTEGER;
618:
619:
620: CURSOR csr_seeded_element_type -- cache -- context -- if not populated
621: (p_element_name IN pay_element_types_f.element_name%TYPE
622: ) IS
623: SELECT element_type_id
624: FROM pay_element_types_f
625: WHERE element_name = p_element_name

Line 624: FROM pay_element_types_f

620: CURSOR csr_seeded_element_type -- cache -- context -- if not populated
621: (p_element_name IN pay_element_types_f.element_name%TYPE
622: ) IS
623: SELECT element_type_id
624: FROM pay_element_types_f
625: WHERE element_name = p_element_name
626: AND business_group_id IS NULL
627: AND legislation_code = 'GB'
628: AND ROWNUM < 2; -- there can be more than effective row

Line 830: FROM pay_element_types_f

826: (p_element_type_id IN NUMBER
827: ,p_effective_date IN DATE
828: ) IS
829: SELECT (fnd_number.canonical_to_number(element_information1) * 7) max_value
830: FROM pay_element_types_f
831: WHERE element_type_id = p_element_type_id
832: AND p_effective_date
833: BETWEEN effective_start_date
834: AND effective_end_date;

Line 881: FROM pay_element_types_f elt

877: ,fnd_number.canonical_to_number(elt.element_information4) max_mpp_weeks
878: ,fnd_number.canonical_to_number(elt.element_information9) high_rate
879: ,fnd_number.canonical_to_number(elt.element_information10) low_rate
880: ,fnd_number.canonical_to_number(elt.element_information14) weeks_higher_rate
881: FROM pay_element_types_f elt
882: WHERE elt.element_type_id = p_smp_element_type_id
883: AND p_effective_date
884: BETWEEN elt.effective_start_date
885: AND elt.effective_end_date;

Line 894: FROM pay_element_types_f

890: (p_element_type_id IN NUMBER
891: ,p_effective_date IN DATE
892: ) IS
893: SELECT (fnd_number.canonical_to_number(element_information4) * 7) max_value
894: FROM pay_element_types_f
895: WHERE element_type_id = p_element_type_id
896: AND p_effective_date
897: BETWEEN effective_start_date
898: AND effective_end_date;