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 3938: psp_element_groups peg,

3934: /***** Modified the following cursor for 11510_CU2 consolidated performance fixes.
3935: CURSOR eg_hier_cur IS
3936: SELECT DISTINCT schedule_hierarchy_id
3937: FROM psp_schedule_hierarchy psh,
3938: psp_element_groups peg,
3939: psp_group_element_list pgel
3940: WHERE psh.business_group_id = p_business_group_id
3941: AND psh.set_of_books_id = p_set_of_books_id
3942: AND peg.business_group_id = p_business_group_id

Line 3957: FROM psp_element_groups peg,

3953: CURSOR eg_hier_cur IS
3954: SELECT schedule_hierarchy_id
3955: FROM psp_schedule_hierarchy psh
3956: WHERE EXISTS (SELECT 1
3957: FROM psp_element_groups peg,
3958: psp_group_element_list pgel
3959: WHERE peg.business_group_id = p_business_group_id
3960: AND peg.set_of_books_id = p_set_of_books_id
3961: AND peg.end_date_active >= r_enc_period.r_period_start_date(1)

Line 3990: psp_element_groups peg

3986: SUM(period_schedule_percent) schedule_percent
3987: FROM psp_matrix_driver pmd,
3988: psp_schedule_lines psl,
3989: psp_schedule_hierarchy psh,
3990: psp_element_groups peg
3991: WHERE run_id = l_run_id
3992: AND psl.schedule_line_id = pmd.schedule_line_id
3993: AND psl.schedule_hierarchy_id = psh.schedule_hierarchy_id
3994: AND psh.element_group_id = peg.element_group_id