APPS.PSP_ADJ_DRIVER dependencies on PSP_ELEMENT_TYPES

Line 133: FROM psp_element_types pet

129: -- End of bug fix 2916848
130: AND pdl.reversal_entry_flag is NULL
131: AND pdl.adjustment_batch_name is null
132: AND EXISTS (SELECT 1
133: FROM psp_element_types pet
134: WHERE pet.element_type_id = ppl.element_type_id
135: AND pet.adjust = 'Y'
136: -- Introduced BG/SOB check fopr bug fix 3098050
137: AND pet.business_group_id = p_business_group_id

Line 211: FROM psp_element_types pet

207: AND ppg.reversal_entry_flag is NULL
208: AND ppg.suspense_org_account_id = pos.organization_account_id(+)
209: AND ppg.adjustment_batch_name is null
210: AND EXISTS (SELECT 1
211: FROM psp_element_types pet
212: WHERE pet.element_type_id = ppg.element_type_id
213: AND pet.adjust = 'Y'
214: -- Introduced BG/SOB check fopr bug fix 3098050
215: AND pet.business_group_id = p_business_group_id

Line 281: FROM psp_element_types pet

277: AND NVL(pal.original_line_flag,'N') ='N'
278: AND pal.reversal_entry_flag is NULL
279: AND pal.adjustment_batch_name is null
280: AND EXISTS (SELECT 1
281: FROM psp_element_types pet
282: WHERE pet.element_type_id = pal.element_type_id
283: AND pet.adjust = 'Y'
284: -- Introduced BG/SOB check fopr bug fix 3098050
285: AND pet.business_group_id = p_business_group_id