APPS.PA_FORECASTITEM_PVT dependencies on PA_PROJECT_ASSIGNMENTS

Line 426: FROM pa_project_assignments proj_asgn

422: proj_asgn.expenditure_organization_id,
423: proj_asgn.expenditure_type,
424: proj_asgn.expenditure_type_class,
425: fcst_tp_amount_type
426: FROM pa_project_assignments proj_asgn
427: WHERE proj_asgn.resource_id = lv_resource_id
428: AND ( (lv_start_date BETWEEN proj_asgn.start_date AND
429: proj_asgn.end_date)
430: OR (lv_end_date BETWEEN proj_asgn.start_date AND

Line 728: FROM pa_project_assignments

724: PA_DEBUG.Init_err_stack(
725: 'PA_FORECASTITEM_PVT.Delete_Forecast_Item');
726:
727: SELECT count(*) into lv_asg_count
728: FROM pa_project_assignments
729: WHERE assignment_id = p_assignment_id;
730: /*
731: Get_Assignment_Dtls( p_assignment_id => p_assignment_id ,
732: x_AsgnDtlRec => TmpAsgnDtlRec,

Line 872: FROM pa_project_assignments

868: expenditure_organization_id,
869: expenditure_type, expenditure_type_class,
870: fcst_tp_amount_type
871: INTO x_AsgnDtlRec
872: FROM pa_project_assignments
873: WHERE assignment_id = p_assignment_id;
874:
875: Print_message('x_AsgnDtlRec.resource_id: ' || x_AsgnDtlRec.resource_id);
876: IF x_AsgnDtlRec.assignment_type = 'OPEN_ASSIGNMENT' THEN

Line 13945: FROM pa_project_assignments proj_asgn

13941:
13942: /* Bug 4918687 SQL ID 14905697 CURSOR asgmt_dtls IS
13943: SELECT proj_asgn.assignment_id,'ERROR'l_process_mode,
13944: proj_asgn.start_date,proj_asgn.end_date
13945: FROM pa_project_assignments proj_asgn
13946: WHERE proj_asgn.expenditure_organization_id = p_orgz_id
13947: AND proj_asgn.template_flag = 'N'
13948: AND p_start_date IS NOT NULL
13949: AND p_end_date IS NOT NULL

Line 13965: FROM pa_project_assignments proj_asgn

13961:
13962: UNION
13963: SELECT proj_asgn.assignment_id,'ERROR'l_process_mode,
13964: proj_asgn.start_date,proj_asgn.end_date
13965: FROM pa_project_assignments proj_asgn
13966: WHERE proj_asgn.expenditure_organization_id = p_orgz_id
13967: AND proj_asgn.template_flag = 'N'
13968: AND p_start_date IS NOT NULL
13969: AND p_end_date IS NULL

Line 13983: FROM pa_project_assignments proj_asgn

13979: trunc(p_start_date) )
13980: UNION
13981: SELECT proj_asgn.assignment_id,'ERROR'l_process_mode,
13982: proj_asgn.start_date,proj_asgn.end_date
13983: FROM pa_project_assignments proj_asgn
13984: WHERE proj_asgn.expenditure_organization_id = p_orgz_id
13985: AND proj_asgn.template_flag = 'N'
13986: AND p_start_date IS NULL
13987: AND p_end_date IS NOT NULL

Line 14001: FROM pa_project_assignments proj_asgn

13997: trunc(p_end_date))
13998: UNION
13999: SELECT proj_asgn.assignment_id,'ERROR'l_process_mode,
14000: proj_asgn.start_date,proj_asgn.end_date
14001: FROM pa_project_assignments proj_asgn
14002: WHERE proj_asgn.expenditure_organization_id = p_orgz_id
14003: AND proj_asgn.template_flag = 'N'
14004: AND p_start_date IS NULL
14005: AND p_end_date IS NULL

Line 14017: FROM pa_project_assignments proj_asgn

14013: frcst_itms.error_flag))
14014: UNION
14015: SELECT proj_asgn.assignment_id,'GENERATE'l_process_mode,
14016: proj_asgn.start_date,proj_asgn.end_date
14017: FROM pa_project_assignments proj_asgn
14018: WHERE proj_asgn.expenditure_organization_id = p_orgz_id
14019: AND proj_asgn.template_flag = 'N'
14020: AND EXISTS ( SELECT NULL
14021: FROM pa_schedules psch

Line 14030: FROM pa_project_assignments proj_asgn

14026:
14027: CURSOR asgmt_dtls IS
14028: SELECT proj_asgn.assignment_id,'ERROR'l_process_mode,
14029: proj_asgn.start_date,proj_asgn.end_date
14030: FROM pa_project_assignments proj_asgn
14031: WHERE proj_asgn.expenditure_organization_id = p_orgz_id
14032: AND proj_asgn.template_flag = 'N'
14033: AND ( EXISTS ( SELECT null
14034: FROM pa_forecast_items frcst_itms

Line 15124: from pa_project_assignments

15120: end if;
15121:
15122: select start_date, end_date
15123: into ld_start_date, ld_end_date
15124: from pa_project_assignments
15125: where assignment_id = p_requirement_source_id;
15126:
15127: print_message('Start calling fetch_fi_hdr');
15128: Fetch_FI_Hdr(