APPS.PSP_ENC_CREATE_LINES dependencies on PSP_SCHEDULE_HIERARCHY

Line 3926: FROM psp_schedule_hierarchy psh

3922: ORDER BY 1;
3923:
3924: CURSOR ls_hier_cur (p_scheduling_types_code IN VARCHAR2) IS
3925: SELECT psh.schedule_hierarchy_id
3926: FROM psp_schedule_hierarchy psh
3927: WHERE psh.business_group_id = p_business_group_id
3928: AND psh.set_of_books_id = p_set_of_books_id
3929: AND psh.scheduling_types_code = p_scheduling_types_code
3930: AND ( (p_scheduling_types_code = 'ET' AND psh.element_type_id = p_element_type_id)

Line 3937: FROM psp_schedule_hierarchy psh,

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

Line 3955: FROM psp_schedule_hierarchy psh

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

Line 3989: psp_schedule_hierarchy psh,

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

Line 9765: FROM psp_schedule_hierarchy psh,

9761: DECODE(g_dff_grouping_option, 'Y', psl.attribute8, NULL),
9762: DECODE(g_dff_grouping_option, 'Y', psl.attribute9, NULL),
9763: DECODE(g_dff_grouping_option, 'Y', psl.attribute10, NULL),
9764: DECODE(psl.expenditure_type, NULL, 'N', 'E') acct_type
9765: FROM psp_schedule_hierarchy psh,
9766: psp_schedule_lines psl
9767: WHERE psh.assignment_id = p_assignment_id
9768: AND psh.element_type_id = p_element_type_id
9769: AND psh.business_group_id = p_business_group_id

Line 9806: psp_schedule_hierarchy psh,

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

Line 9851: FROM psp_schedule_hierarchy psh,

9847: DECODE(g_dff_grouping_option, 'Y', psl.attribute8, NULL),
9848: DECODE(g_dff_grouping_option, 'Y', psl.attribute9, NULL),
9849: DECODE(g_dff_grouping_option, 'Y', psl.attribute10, NULL),
9850: DECODE(psl.expenditure_type, NULL, 'N', 'E') acct_type
9851: FROM psp_schedule_hierarchy psh,
9852: psp_schedule_lines psl
9853: WHERE psh.scheduling_types_code = 'A'
9854: AND psh.element_group_id IS NULL
9855: AND psh.element_type_id IS NULL