DBA Data[Home] [Help]

APPS.PSP_LABOR_DIST dependencies on PSP_SCHEDULE_HIERARCHY

Line 1408: FROM psp_schedule_hierarchy psh,

1404: decode(g_dff_grouping_option, 'Y',NVL(p_attribute7, psl.attribute7)) attribute7,
1405: decode(g_dff_grouping_option, 'Y',NVL(p_attribute8, psl.attribute8)) attribute8,
1406: decode(g_dff_grouping_option, 'Y',NVL(p_attribute9, psl.attribute9)) attribute9,
1407: decode(g_dff_grouping_option, 'Y',NVL(p_attribute10, psl.attribute10)) attribute10
1408: FROM psp_schedule_hierarchy psh,
1409: psp_schedule_lines psl
1410: WHERE psh.business_group_id = p_business_group_id
1411: AND psh.set_of_books_id = p_set_of_books_id
1412: AND psh.business_group_id = psl.business_group_id

Line 1949: psp_schedule_hierarchy psh,

1945: decode(g_dff_grouping_option, 'Y',NVL(p_attribute9, psl.attribute9)) attribute9,
1946: decode(g_dff_grouping_option, 'Y',NVL(p_attribute10, psl.attribute10)) attribute10
1947: FROM psp_element_types pet,
1948: psp_group_element_list pgel,
1949: psp_schedule_hierarchy psh,
1950: psp_schedule_lines psl
1951: WHERE pet.element_type_id = p_element_type_id
1952: -- Introduced the following BG/SOB check for bug fix 3098050
1953: AND pet.business_group_id = p_business_group_id

Line 2533: FROM psp_schedule_hierarchy psh,

2529: decode(g_dff_grouping_option, 'Y',NVL(p_attribute7, psl.attribute7)) attribute7,
2530: decode(g_dff_grouping_option, 'Y',NVL(p_attribute8, psl.attribute8)) attribute8,
2531: decode(g_dff_grouping_option, 'Y',NVL(p_attribute9, psl.attribute9)) attribute9,
2532: decode(g_dff_grouping_option, 'Y',NVL(p_attribute10, psl.attribute10)) attribute10
2533: FROM psp_schedule_hierarchy psh,
2534: psp_schedule_lines psl
2535: WHERE psh.business_group_id = p_business_group_id
2536: AND psh.set_of_books_id = p_set_of_books_id
2537: AND psh.scheduling_types_code = 'A'

Line 6097: psp_schedule_hierarchy psh

6093: FROM psp_distribution_lines pdl,
6094: psp_payroll_lines ppl,
6095: psp_payroll_sub_lines ppsl,
6096: psp_Schedule_lines psl,
6097: psp_schedule_hierarchy psh
6098: WHERE
6099: ppl.payroll_control_id = p_payroll_control_id
6100: AND ppl.payroll_line_id = ppsl.payroll_line_id
6101: and ppsl.payroll_sub_line_id=pdl.payroll_sub_line_id