APPS.PAY_PRETAX_UDFS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 10

SELECT	nvl(etype.element_information4, 'NOT ENTERED')
INTO	l_ptx_period_type
FROM	pay_element_types_f            	ETYPE
WHERE  	ETYPE.element_information20	= p_eletype_id
AND	p_date_earned BETWEEN ETYPE.effective_start_date
		          AND ETYPE.effective_end_date;

Line: 33

SELECT	NVL(etype.element_information7, 'NOT ENTERED')
INTO	l_ptx_row_type
FROM	pay_element_types_f            	ETYPE
WHERE  	ETYPE.element_information20	= p_eletype_id
AND	p_date_earned BETWEEN ETYPE.effective_start_date
		          AND ETYPE.effective_end_date;

Line: 57

SELECT	NVL(etype.element_information6, 'NOT ENTERED')
INTO	l_ptx_paytab
FROM	pay_element_types_f            	ETYPE
WHERE  	ETYPE.element_information20	= p_eletype_id
AND	p_date_earned BETWEEN ETYPE.effective_start_date
		          AND ETYPE.effective_end_date;

Line: 82

SELECT fnd_number.canonical_to_number(BCONTR.employee_contribution)
INTO   l_ee_contr
FROM   pay_element_types_f PET,
       ben_benefit_contributions_f BCONTR
WHERE  PET.element_information20 = p_eletype_id
AND    BCONTR.element_type_id = PET.element_type_id
AND    BCONTR.coverage_type = p_coverage
AND    p_date_earned BETWEEN BCONTR.effective_start_date
                         AND BCONTR.effective_end_date;

Line: 110

SELECT fnd_number.canonical_to_number(BCONTR.employer_contribution)
INTO   l_er_contr
FROM   pay_element_types_f PET,
       ben_benefit_contributions_f BCONTR
WHERE  PET.element_information20 = p_eletype_id
AND    BCONTR.element_type_id = PET.element_type_id
AND    BCONTR.coverage_type = p_coverage
AND    p_date_earned BETWEEN BCONTR.effective_start_date
                         AND BCONTR.effective_end_date;