DBA Data[Home] [Help]

APPS.PAY_PRETAX_UDFS dependencies on BEN_BENEFIT_CONTRIBUTIONS_F

Line 85: ben_benefit_contributions_f BCONTR

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
89: AND p_date_earned BETWEEN BCONTR.effective_start_date

Line 113: ben_benefit_contributions_f BCONTR

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
117: AND p_date_earned BETWEEN BCONTR.effective_start_date