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_GROUP_ELEMENT_LIST

Line 3939: psp_group_element_list pgel

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
3943: AND peg.set_of_books_id = p_set_of_books_id

Line 3958: psp_group_element_list pgel

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)
3962: AND peg.start_date_active <= r_enc_period.r_period_end_date(l_period_count)

Line 9805: psp_group_element_list pgel,

9801: DECODE(g_dff_grouping_option, 'Y', psl.attribute9, NULL),
9802: DECODE(g_dff_grouping_option, 'Y', psl.attribute10, NULL),
9803: DECODE(psl.expenditure_type, NULL, 'N', 'E') acct_type
9804: FROM psp_element_types pet,
9805: psp_group_element_list pgel,
9806: psp_schedule_hierarchy psh,
9807: psp_schedule_lines psl
9808: WHERE pet.element_type_id = p_element_type_id
9809: AND pet.business_group_id = p_business_group_id