DBA Data[Home] [Help]

APPS.PQP_GB_PENSION_SCHEME_UPDATE dependencies on PAY_ELEMENT_TYPES_F

Line 25: pay_element_types_f petf,

21: Cursor csr_element_and_type is
22: Select petf.element_name,
23: pee.eei_information8 scheme_type
24: From pay_element_classifications pec,
25: pay_element_types_f petf,
26: pay_element_type_extra_info pee
27: Where pec.classification_name ='Pre Tax Deductions'
28: and pec.legislation_code='GB'
29: and petf.classification_id = pec.classification_id

Line 74: pay_element_types_f petf,

70: Cursor csr_element_details is
71: select petf.element_type_id,petf.element_name,
72: upper(hr.description) description
73: from hr_lookups hr,
74: pay_element_types_f petf,
75: pay_element_classifications pec
76: where hr.lookup_type='PQP_GB_PENSION_SCHEME_UPDATE'
77: and hr.enabled_flag='Y'
78: and (upper(hr.description) in ('COMP','COSR')