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 4174: psp_group_element_list pgel

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

Line 4193: psp_group_element_list pgel

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

Line 10435: psp_group_element_list pgel,

10431: DECODE(g_dff_grouping_option, 'Y', psl.attribute9, NULL),
10432: DECODE(g_dff_grouping_option, 'Y', psl.attribute10, NULL),
10433: DECODE(psl.expenditure_type, NULL, 'N', 'E') acct_type
10434: FROM psp_element_types pet,
10435: psp_group_element_list pgel,
10436: psp_schedule_hierarchy psh,
10437: psp_schedule_lines psl
10438: WHERE pet.element_type_id = p_element_type_id
10439: AND pet.business_group_id = p_business_group_id