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_ENC_CREATE_LINES dependencies on PSP_ELEMENT_GROUPS

Line 4173: psp_element_groups peg,

4169: /***** Modified the following cursor for 11510_CU2 consolidated performance fixes.
4170: CURSOR eg_hier_cur IS
4171: SELECT DISTINCT schedule_hierarchy_id
4172: FROM psp_schedule_hierarchy psh,
4173: psp_element_groups peg,
4174: psp_group_element_list pgel
4175: WHERE psh.business_group_id = p_business_group_id
4176: AND psh.set_of_books_id = p_set_of_books_id
4177: AND peg.business_group_id = p_business_group_id

Line 4192: FROM psp_element_groups peg,

4188: CURSOR eg_hier_cur IS
4189: SELECT schedule_hierarchy_id
4190: FROM psp_schedule_hierarchy psh
4191: WHERE EXISTS (SELECT 1
4192: FROM psp_element_groups peg,
4193: psp_group_element_list pgel
4194: WHERE peg.business_group_id = p_business_group_id
4195: AND peg.set_of_books_id = p_set_of_books_id
4196: AND peg.end_date_active >= r_enc_period.r_period_start_date(1)

Line 4226: psp_element_groups peg

4222: SUM(period_schedule_percent) schedule_percent
4223: FROM psp_matrix_driver pmd,
4224: psp_schedule_lines psl,
4225: psp_schedule_hierarchy psh,
4226: psp_element_groups peg
4227: WHERE run_id = l_run_id
4228: AND psl.schedule_line_id = pmd.schedule_line_id
4229: AND psl.schedule_hierarchy_id = psh.schedule_hierarchy_id
4230: AND psh.element_group_id = peg.element_group_id