APPS.PAY_SA_GOSI_REPORTS dependencies on PAY_ELEMENT_TYPES_F

Line 1696: FROM pay_element_types_f

1692: /****Fetch headcounts****/
1693: /*Fetch element_type_id for elements GOSI, Employee GOSI Annuities, Employee GOSI Hazards*/
1694: SELECT element_type_id
1695: INTO l_gosi_id
1696: FROM pay_element_types_f
1697: WHERE element_name = 'GOSI'
1698: AND legislation_code = 'SA'
1699: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;
1700: SELECT element_type_id

Line 1702: FROM pay_element_types_f

1698: AND legislation_code = 'SA'
1699: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;
1700: SELECT element_type_id
1701: INTO l_employer_gosi_haz_id
1702: FROM pay_element_types_f
1703: WHERE element_name = 'Employer GOSI Hazards'
1704: AND legislation_code = 'SA'
1705: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;
1706: SELECT element_type_id

Line 1708: FROM pay_element_types_f

1704: AND legislation_code = 'SA'
1705: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;
1706: SELECT element_type_id
1707: INTO l_employee_gosi_ann_id
1708: FROM pay_element_types_f
1709: WHERE element_name = 'Employee GOSI Annuities'
1710: AND legislation_code = 'SA'
1711: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;
1712: /*Query for fetching headcount modified after the enhacement*/