eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 13948: FROM pa_project_assignments proj_asgn

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

Line 13968: FROM pa_project_assignments proj_asgn

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

Line 13986: FROM pa_project_assignments proj_asgn

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

Line 14004: FROM pa_project_assignments proj_asgn

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

Line 14020: FROM pa_project_assignments proj_asgn

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

Line 14034: FROM pa_project_assignments proj_asgn

14030: /* Commented as part of bug#10071003
14031: CURSOR asgmt_dtls IS
14032: SELECT proj_asgn.assignment_id,'ERROR'l_process_mode,
14033: proj_asgn.start_date,proj_asgn.end_date
14034: FROM pa_project_assignments proj_asgn
14035: WHERE proj_asgn.expenditure_organization_id = p_orgz_id
14036: AND proj_asgn.template_flag = 'N'
14037: AND ( EXISTS ( SELECT null
14038: FROM pa_forecast_items frcst_itms

Line 14055: -- Query assignment_type = 'OPEN_ASSIGNMENT' based on pa_project_assignments.expenditure_organization_id

14051: AND psch.forecast_txn_generated_flag = 'N')
14052: ); */
14053: -- Bug# 10071003 - Added - Start
14054: CURSOR asgmt_dtls IS
14055: -- Query assignment_type = 'OPEN_ASSIGNMENT' based on pa_project_assignments.expenditure_organization_id
14056: SELECT proj_asgn.assignment_id,'ERROR'l_process_mode,
14057: proj_asgn.start_date,proj_asgn.end_date
14058: FROM pa_project_assignments proj_asgn
14059: WHERE proj_asgn.expenditure_organization_id = p_orgz_id

Line 14058: FROM pa_project_assignments proj_asgn

14054: CURSOR asgmt_dtls IS
14055: -- Query assignment_type = 'OPEN_ASSIGNMENT' based on pa_project_assignments.expenditure_organization_id
14056: SELECT proj_asgn.assignment_id,'ERROR'l_process_mode,
14057: proj_asgn.start_date,proj_asgn.end_date
14058: FROM pa_project_assignments proj_asgn
14059: WHERE proj_asgn.expenditure_organization_id = p_orgz_id
14060: AND proj_asgn.template_flag = 'N'
14061: AND proj_asgn.assignment_type = 'OPEN_ASSIGNMENT'
14062: AND ( EXISTS ( SELECT null

Line 14080: FROM pa_project_assignments proj_asgn,

14076: UNION
14077: -- Query assignment_type in ('STAFFED_ASSIGNMENT','STAFFED_ADMIN_ASSIGNMENT') based on pa_resources_denorm.resource_organization_id
14078: SELECT proj_asgn.assignment_id,'ERROR'l_process_mode,
14079: proj_asgn.start_date,proj_asgn.end_date
14080: FROM pa_project_assignments proj_asgn,
14081: pa_resources_denorm prd
14082: WHERE proj_asgn.template_flag = 'N'
14083: AND proj_asgn.assignment_type IN ('STAFFED_ASSIGNMENT','STAFFED_ADMIN_ASSIGNMENT')
14084: AND proj_asgn.resource_id = prd.resource_id

Line 15179: from pa_project_assignments

15175: end if;
15176:
15177: select start_date, end_date
15178: into ld_start_date, ld_end_date
15179: from pa_project_assignments
15180: where assignment_id = p_requirement_source_id;
15181:
15182: print_message('Start calling fetch_fi_hdr');
15183: Fetch_FI_Hdr(