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 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

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

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

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

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

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

1667: a.attribute8,
1668: a.attribute9,
1669: a.attribute10
1670: FROM psp_adjustment_lines a,
1671: psp_group_element_list b
1672: WHERE a.batch_name = p_batch_name
1673: and a.business_group_id = p_business_group_id
1674: and a.set_of_books_id = p_set_of_books_id
1675: and b.element_type_id(+) = a.element_type_id

Line 1881: psp_group_element_list b

1877: p_run_id,
1878: p_set_of_books_id,
1879: p_business_group_id
1880: FROM psp_adjustment_lines a,
1881: psp_group_element_list b
1882: WHERE a.batch_name = p_batch_name
1883: and a.business_group_id = p_business_group_id
1884: and a.set_of_books_id = p_set_of_books_id
1885: and b.element_type_id(+) = a.element_type_id