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_GROUP_ELEMENT_LIST

Line 103: --psp_group_element_list pgel, --- added for DA-ENH Modified to inline query for bug 3658235

99: psp_distribution_lines_history pdl,
100: psp_payroll_lines ppl,
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

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 185: --psp_group_element_list pgel, --- added for DA-ENH Modified to inline query for bug fix 3658235

181: DECODE(g_dff_grouping_option, 'Y', DECODE(ppg.suspense_org_account_id, NULL, ppg.attribute10, pos.attribute10), NULL) attribute10
182: FROM
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

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 257: --psp_group_element_list pgel, --- added table for DA-ENH Modified to inline query for bug fix 3658235

253: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
254: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
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

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 1680: psp_group_element_list b

1676: a.attribute8,
1677: a.attribute9,
1678: a.attribute10
1679: FROM psp_adjustment_lines a,
1680: psp_group_element_list b
1681: WHERE a.batch_name = p_batch_name
1682: and a.business_group_id = p_business_group_id
1683: and a.set_of_books_id = p_set_of_books_id
1684: and b.element_type_id(+) = a.element_type_id

Line 1890: psp_group_element_list b

1886: p_run_id,
1887: p_set_of_books_id,
1888: p_business_group_id
1889: FROM psp_adjustment_lines a,
1890: psp_group_element_list b
1891: WHERE a.batch_name = p_batch_name
1892: and a.business_group_id = p_business_group_id
1893: and a.set_of_books_id = p_set_of_books_id
1894: and b.element_type_id(+) = a.element_type_id