APPS.PSP_ADJ_DRIVER dependencies on PSP_ELEMENT_GROUPS

Line 105: FROM psp_element_groups peg, psp_group_element_list pgel

101: psp_payroll_sub_lines ppsl,
102: psp_summary_lines psl,
103: --psp_group_element_list pgel, --- added for DA-ENH Modified to inline query for bug 3658235
104: (SELECT peg.element_group_id, pgel.element_type_id
105: FROM psp_element_groups peg, psp_group_element_list pgel
106: WHERE business_group_id = p_business_group_id
107: AND set_of_books_id = p_set_of_books_id
108: AND peg.element_group_id (+) = pgel.element_group_id
109: and (peg.start_date_active between p_begin_date and p_end_date -- Bug 7582233

Line 120: -- Introduced BG/SOB check on psp_element_groups for bug fix 3098050

116: AND psl.business_group_id = p_business_group_id
117: AND psl.set_of_books_id = p_set_of_books_id
118: AND pdl.distribution_date between p_begin_date and p_end_date
119: AND pegl.element_type_id(+) = ppl.element_type_id --- added for DA-ENH
120: -- Introduced BG/SOB check on psp_element_groups for bug fix 3098050
121: --AND peg.element_group_id(+) = pgel.element_group_id
122: -- AND NVL(peg.business_group_id, p_business_group_id) = p_business_group_id -- Introduced NVL for bug fix 3145038, Commented for 3658235
123: -- AND NVL(peg.set_of_books_id, p_set_of_books_id) = p_set_of_books_id -- Introduced NVL for bug fix 3145038, Commented for 3658235
124: AND pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id

Line 185: FROM psp_element_groups peg, psp_group_element_list pgel

181: psp_pre_gen_dist_lines_history ppg,
182: psp_organization_accounts pos ,
183: --psp_group_element_list pgel, --- added for DA-ENH Modified to inline query for bug fix 3658235
184: (SELECT peg.element_group_id, pgel.element_type_id
185: FROM psp_element_groups peg, psp_group_element_list pgel
186: WHERE business_group_id = p_business_group_id
187: AND set_of_books_id = p_set_of_books_id
188: AND peg.element_group_id (+) = pgel.element_group_id
189: and (peg.start_date_active between p_begin_date and p_end_date -- Bug 7582233

Line 202: -- Introduced BG/SOB check on psp_element_groups for bug fix 3098050

198: AND ppc.payroll_control_id = ppg.payroll_control_id
199: AND ppc.currency_code = p_currency_code
200: -- End of bug fix 2916848
201: AND pegl.element_type_id(+) = ppg.element_type_id -- added for DA-ENH
202: -- Introduced BG/SOB check on psp_element_groups for bug fix 3098050
203: --AND peg.element_group_id(+) = pgel.element_group_id
204: -- AND NVL(peg.business_group_id, p_business_group_id) = p_business_group_id -- Introduced NVL for bug fix 3145038, Commented for bug 3658235
205: -- AND NVL(peg.set_of_books_id, p_set_of_books_id) = p_set_of_books_id -- Introduced NVL for bug fix 3145038, Commented for bug 3658235
206: AND ppg.status_code = 'A'

Line 255: FROM psp_element_groups peg, psp_group_element_list pgel

251: FROM
252: psp_adjustment_lines_history pal,
253: --psp_group_element_list pgel, --- added table for DA-ENH Modified to inline query for bug fix 3658235
254: (SELECT peg.element_group_id, pgel.element_type_id
255: FROM psp_element_groups peg, psp_group_element_list pgel
256: WHERE business_group_id = p_business_group_id
257: AND set_of_books_id = p_set_of_books_id
258: AND peg.element_group_id (+) = pgel.element_group_id
259: and (peg.start_date_active between p_begin_date and p_end_date -- Bug 7582233

Line 272: -- Introduced BG/SOB check on psp_element_groups for bug fix 3098050

268: AND ppc.payroll_control_id = pal.payroll_control_id
269: AND ppc.currency_code = p_currency_code
270: -- End of bug fix 2916848
271: AND pegl.element_type_id(+) = pal.element_type_id
272: -- Introduced BG/SOB check on psp_element_groups for bug fix 3098050
273: --AND peg.element_group_id(+) = pgel.element_group_id
274: -- AND NVL(peg.business_group_id, p_business_group_id) = p_business_group_id -- Introduced NVL for bug fix 3145038, Commented for bug 3658235
275: -- AND NVL(peg.set_of_books_id, p_set_of_books_id) = p_set_of_books_id -- Introduced NVL for bug fix 3145038, Commented for bug 3658235
276: AND pal.status_code = 'A'