DBA Data[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on PSP_DEFAULT_LABOR_SCHEDULES

Line 3909: psp_default_labor_schedules pdls

3905: SELECT GREATEST(l_min_start_date, paf.effective_start_date, schedule_begin_date) schedule_begin_date,
3906: LEAST(l_max_end_date, paf.effective_end_date, schedule_end_date) schedule_end_date,
3907: SUM(schedule_percent) schedule_percent
3908: FROM per_assignments_f paf,
3909: psp_default_labor_schedules pdls
3910: WHERE paf.assignment_id = p_assignment_id
3911: AND l_min_start_date <= paf.effective_end_date
3912: AND l_max_end_date >= paf.effective_start_date
3913: AND paf.organization_id = pdls.organization_id

Line 9916: FROM psp_default_labor_schedules pdls

9912: DECODE(g_dff_grouping_option, 'Y', pdls.attribute8, NULL),
9913: DECODE(g_dff_grouping_option, 'Y', pdls.attribute9, NULL),
9914: DECODE(g_dff_grouping_option, 'Y', pdls.attribute10, NULL),
9915: DECODE(pdls.expenditure_type, NULL, 'N', 'E') acct_type
9916: FROM psp_default_labor_schedules pdls
9917: WHERE pdls.business_group_id = p_business_group_id
9918: AND pdls.set_of_books_id = p_set_of_books_id
9919: AND pdls.organization_id = p_organization_id
9920: AND ( pdls.gl_code_combination_id IS NOT NULL