APPS.PAY_PRETAX_UDFS dependencies on PAY_ELEMENT_TYPES_F

Line 12: FROM pay_element_types_f ETYPE

8: BEGIN
9:
10: SELECT nvl(etype.element_information4, 'NOT ENTERED')
11: INTO l_ptx_period_type
12: FROM pay_element_types_f ETYPE
13: WHERE ETYPE.element_information20 = p_eletype_id
14: AND p_date_earned BETWEEN ETYPE.effective_start_date
15: AND ETYPE.effective_end_date;
16:

Line 35: FROM pay_element_types_f ETYPE

31: BEGIN
32:
33: SELECT NVL(etype.element_information7, 'NOT ENTERED')
34: INTO l_ptx_row_type
35: FROM pay_element_types_f ETYPE
36: WHERE ETYPE.element_information20 = p_eletype_id
37: AND p_date_earned BETWEEN ETYPE.effective_start_date
38: AND ETYPE.effective_end_date;
39:

Line 59: FROM pay_element_types_f ETYPE

55: BEGIN
56:
57: SELECT NVL(etype.element_information6, 'NOT ENTERED')
58: INTO l_ptx_paytab
59: FROM pay_element_types_f ETYPE
60: WHERE ETYPE.element_information20 = p_eletype_id
61: AND p_date_earned BETWEEN ETYPE.effective_start_date
62: AND ETYPE.effective_end_date;
63:

Line 84: FROM pay_element_types_f PET,

80: BEGIN
81:
82: SELECT fnd_number.canonical_to_number(BCONTR.employee_contribution)
83: INTO l_ee_contr
84: FROM pay_element_types_f PET,
85: ben_benefit_contributions_f BCONTR
86: WHERE PET.element_information20 = p_eletype_id
87: AND BCONTR.element_type_id = PET.element_type_id
88: AND BCONTR.coverage_type = p_coverage

Line 112: FROM pay_element_types_f PET,

108: BEGIN
109:
110: SELECT fnd_number.canonical_to_number(BCONTR.employer_contribution)
111: INTO l_er_contr
112: FROM pay_element_types_f PET,
113: ben_benefit_contributions_f BCONTR
114: WHERE PET.element_information20 = p_eletype_id
115: AND BCONTR.element_type_id = PET.element_type_id
116: AND BCONTR.coverage_type = p_coverage