eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 max(peg.element_group_id) element_group_id, pgel.element_type_id -- Bug 14128743
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 (p_begin_date between peg.start_date_active and peg.end_date_active -- Bug 8970980

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

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

Line 187: FROM psp_element_groups peg, psp_group_element_list pgel

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

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

202: AND ppc.payroll_control_id = ppg.payroll_control_id
203: AND ppc.currency_code = p_currency_code
204: -- End of bug fix 2916848
205: AND pegl.element_type_id(+) = ppg.element_type_id -- added for DA-ENH
206: -- Introduced BG/SOB check on psp_element_groups for bug fix 3098050
207: --AND peg.element_group_id(+) = pgel.element_group_id
208: -- AND NVL(peg.business_group_id, p_business_group_id) = p_business_group_id -- Introduced NVL for bug fix 3145038, Commented for bug 3658235
209: -- 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
210: AND ppg.status_code = 'A'

Line 259: FROM psp_element_groups peg, psp_group_element_list pgel

255: FROM
256: psp_adjustment_lines_history pal,
257: --psp_group_element_list pgel, --- added table for DA-ENH Modified to inline query for bug fix 3658235
258: (SELECT max(peg.element_group_id) element_group_id, pgel.element_type_id -- Bug 14128743
259: FROM psp_element_groups peg, psp_group_element_list pgel
260: WHERE business_group_id = p_business_group_id
261: AND set_of_books_id = p_set_of_books_id
262: AND peg.element_group_id (+) = pgel.element_group_id
263: and (p_begin_date between peg.start_date_active and peg.end_date_active -- Bug 8970980

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

274: AND ppc.payroll_control_id = pal.payroll_control_id
275: AND ppc.currency_code = p_currency_code
276: -- End of bug fix 2916848
277: AND pegl.element_type_id(+) = pal.element_type_id
278: -- Introduced BG/SOB check on psp_element_groups for bug fix 3098050
279: --AND peg.element_group_id(+) = pgel.element_group_id
280: -- AND NVL(peg.business_group_id, p_business_group_id) = p_business_group_id -- Introduced NVL for bug fix 3145038, Commented for bug 3658235
281: -- 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
282: AND pal.status_code = 'A'