DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_PVT dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 336: l_migration_code pa_resource_lists_all_bg.migration_code%TYPE := NULL;

332:
333:
334:
335: -- Bug 4583454, jwhite, 12-SEP-05 -------------------
336: l_migration_code pa_resource_lists_all_bg.migration_code%TYPE := NULL;
337: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%TYPE := NULL;
338:
339:
340:

Line 337: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%TYPE := NULL;

333:
334:
335: -- Bug 4583454, jwhite, 12-SEP-05 -------------------
336: l_migration_code pa_resource_lists_all_bg.migration_code%TYPE := NULL;
337: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%TYPE := NULL;
338:
339:
340:
341: CURSOR c_chk_rej_codes

Line 714: FROM pa_resource_lists_all_bg

710:
711: SELECT migration_code
712: ,uncategorized_flag
713: INTO l_migration_code, l_uncategorized_flag
714: FROM pa_resource_lists_all_bg
715: WHERE resource_list_id = l_resource_list_id;
716:
717:
718: IF ( (nvl(l_migration_code,'M') = 'M')

Line 2733: l_dummy_res_list_id PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE;

2729: --Insert a new record into pa_resoruce_assignments
2730:
2731:
2732: DECLARE
2733: l_dummy_res_list_id PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE;
2734: l_dummy_row_id ROWID;
2735: l_dummy_ra_id PA_RESOURCE_ASSIGNMENTS.resource_assignment_id%TYPE;
2736: BEGIN
2737: