APPS.PSP_ADJ_DRIVER dependencies on PSP_ELEMENT_TYPES

Line 135: FROM psp_element_types pet

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

Line 215: FROM psp_element_types pet

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

Line 287: FROM psp_element_types pet

283: AND NVL(pal.original_line_flag,'N') ='N'
284: AND pal.reversal_entry_flag is NULL
285: AND pal.adjustment_batch_name is null
286: AND EXISTS (SELECT 1
287: FROM psp_element_types pet
288: WHERE pet.element_type_id = pal.element_type_id
289: AND pet.adjust = 'Y'
290: -- Introduced BG/SOB check fopr bug fix 3098050
291: AND pet.business_group_id = p_business_group_id