DBA Data[Home] [Help]

APPS.PQP_GB_PENSION_SCHEME_UPDATE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 26: pay_element_type_extra_info pee

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
30: and sysdate between

Line 119: update pay_element_type_extra_info pee

115: If element_details_tab.count>0 Then
116:
117: For i in element_details_tab.first..element_details_tab.last loop
118:
119: update pay_element_type_extra_info pee
120: set pee.eei_information8 = element_details_tab(i).description
121: where pee.element_type_id = element_details_tab(i).element_type_id
122: and pee.information_type = 'PQP_GB_PENSION_SCHEME_INFO'
123: and pee.eei_information_category= 'PQP_GB_PENSION_SCHEME_INFO'