APPS.PSP_ENC_CREATE_LINES dependencies on PSP_SCHEDULE_HIERARCHY

Line 4161: FROM psp_schedule_hierarchy psh

4157: ORDER BY 1;
4158:
4159: CURSOR ls_hier_cur (p_scheduling_types_code IN VARCHAR2) IS
4160: SELECT psh.schedule_hierarchy_id
4161: FROM psp_schedule_hierarchy psh
4162: WHERE psh.business_group_id = p_business_group_id
4163: AND psh.set_of_books_id = p_set_of_books_id
4164: AND psh.scheduling_types_code = p_scheduling_types_code
4165: AND ( (p_scheduling_types_code = 'ET' AND psh.element_type_id = p_element_type_id)

Line 4172: FROM psp_schedule_hierarchy psh,

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

Line 4190: FROM psp_schedule_hierarchy psh

4186:
4187: -- Modified cursor for 11510_CU2 consloidated performance fixes.
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

Line 4225: psp_schedule_hierarchy psh,

4221: LEAST(l_max_end_date, peg.end_date_active, period_end_date) period_end_date,
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

Line 10395: FROM psp_schedule_hierarchy psh,

10391: DECODE(g_dff_grouping_option, 'Y', psl.attribute8, NULL),
10392: DECODE(g_dff_grouping_option, 'Y', psl.attribute9, NULL),
10393: DECODE(g_dff_grouping_option, 'Y', psl.attribute10, NULL),
10394: DECODE(psl.expenditure_type, NULL, 'N', 'E') acct_type
10395: FROM psp_schedule_hierarchy psh,
10396: psp_schedule_lines psl
10397: WHERE psh.assignment_id = p_assignment_id
10398: AND psh.element_type_id = p_element_type_id
10399: AND psh.business_group_id = p_business_group_id

Line 10436: psp_schedule_hierarchy psh,

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
10440: AND pet.set_of_books_id = p_set_of_books_id

Line 10481: FROM psp_schedule_hierarchy psh,

10477: DECODE(g_dff_grouping_option, 'Y', psl.attribute8, NULL),
10478: DECODE(g_dff_grouping_option, 'Y', psl.attribute9, NULL),
10479: DECODE(g_dff_grouping_option, 'Y', psl.attribute10, NULL),
10480: DECODE(psl.expenditure_type, NULL, 'N', 'E') acct_type
10481: FROM psp_schedule_hierarchy psh,
10482: psp_schedule_lines psl
10483: WHERE psh.scheduling_types_code = 'A'
10484: AND psh.element_group_id IS NULL
10485: AND psh.element_type_id IS NULL