DBA Data[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on PSP_DEFAULT_LABOR_SCHEDULES

Line 4144: psp_default_labor_schedules pdls

4140: SELECT GREATEST(l_min_start_date, paf.effective_start_date, schedule_begin_date) schedule_begin_date,
4141: LEAST(l_max_end_date, paf.effective_end_date, schedule_end_date) schedule_end_date,
4142: SUM(schedule_percent) schedule_percent
4143: FROM per_assignments_f paf,
4144: psp_default_labor_schedules pdls
4145: WHERE paf.assignment_id = p_assignment_id
4146: AND l_min_start_date <= paf.effective_end_date
4147: AND l_max_end_date >= paf.effective_start_date
4148: AND paf.organization_id = pdls.organization_id

Line 10546: FROM psp_default_labor_schedules pdls

10542: DECODE(g_dff_grouping_option, 'Y', pdls.attribute8, NULL),
10543: DECODE(g_dff_grouping_option, 'Y', pdls.attribute9, NULL),
10544: DECODE(g_dff_grouping_option, 'Y', pdls.attribute10, NULL),
10545: DECODE(pdls.expenditure_type, NULL, 'N', 'E') acct_type
10546: FROM psp_default_labor_schedules pdls
10547: WHERE pdls.business_group_id = p_business_group_id
10548: AND pdls.set_of_books_id = p_set_of_books_id
10549: AND pdls.organization_id = p_organization_id
10550: AND ( pdls.gl_code_combination_id IS NOT NULL