APPS.PQP_GB_TP_CONTRIBUTION_REPORT dependencies on PAY_ELEMENT_TYPES_F

Line 53: FROM pay_element_types_f pet

49: /* To fetch the seeded information element's type id */
50: CURSOR c_element_type_id
51: IS
52: SELECT pet.element_type_id
53: FROM pay_element_types_f pet
54: WHERE pet.legislation_code = 'GB'
55: AND P_DATE_EARNED BETWEEN pet.effective_start_date AND pet.effective_end_date
56: AND pet.element_name = 'Tiered Contributions Information';
57: /* To fetch the original payroll run's result values for Pension Tier */

Line 156: FROM pay_element_types_f pet

152: /* To fetch the seeded information element's type id */
153: CURSOR c_element_type_id
154: IS
155: SELECT pet.element_type_id
156: FROM pay_element_types_f pet
157: WHERE pet.legislation_code = 'GB'
158: AND P_DATE_EARNED BETWEEN pet.effective_start_date AND pet.effective_end_date
159: AND pet.element_name = 'Tiered Contributions Information';
160: /* To fetch the original payroll run's result values for Pension Tier */

Line 341: FROM pay_element_types_f pet

337: ORDER BY tier;
338: ---------------------
339: CURSOR csr_element_type_details(p_effective_date DATE) IS
340: SELECT pet.element_type_id
341: FROM pay_element_types_f pet
342: WHERE pet.legislation_code = 'GB'
343: AND p_effective_date BETWEEN pet.effective_start_date
344: AND pet.effective_end_date
345: AND pet.element_name = 'Tiered Contributions Information';

Line 347: CURSOR csr_input_value_details(p_element_type_id pay_element_types_f.element_type_id%TYPE

343: AND p_effective_date BETWEEN pet.effective_start_date
344: AND pet.effective_end_date
345: AND pet.element_name = 'Tiered Contributions Information';
346: ---------------------
347: CURSOR csr_input_value_details(p_element_type_id pay_element_types_f.element_type_id%TYPE
348: , p_effective_date DATE) IS
349: SELECT substr (name
350: ,length (name)
351: ,1) abc