APPS.PA_PROGRESS_REPORT_UTILS dependencies on PA_PROGRESS_REPORT_VERS

Line 29: FROM PA_PROGRESS_REPORT_VERS

25: l_Report_Start_Date Date;
26:
27: Cursor C is
28: select (MAX(Report_End_Date))
29: FROM PA_PROGRESS_REPORT_VERS
30: WHERE Object_Id = P_Object_Id
31: AND Object_Type = P_Object_Type
32: AND Report_Status_Code = decode(Publish_Report_Flag,'Y','PROGRESS_REPORT_PUBLISHED',Report_Status_Code);
33:

Line 36: FROM PA_PROGRESS_REPORT_VERS

32: AND Report_Status_Code = decode(Publish_Report_Flag,'Y','PROGRESS_REPORT_PUBLISHED',Report_Status_Code);
33:
34: Cursor C1 is
35: select (MAX(Report_End_Date))
36: FROM PA_PROGRESS_REPORT_VERS
37: WHERE Object_Id = P_Object_Id
38: AND Object_Type = P_Object_Type
39: AND report_type_id = p_report_type_id
40: AND Report_Status_Code = decode(Publish_Report_Flag,'Y','PROGRESS_REPORT_PUBLISHED',Report_Status_Code);

Line 120: ,pa_progress_report_vers prv

116: Cursor C1 is
117: Select nvl(approval_required,'N') approval_required
118: -- ,nvl(auto_publish,'N') auto_publish
119: from pa_object_page_layouts pop
120: ,pa_progress_report_vers prv
121: where pop.object_type = prv.object_type
122: and pop.object_id = prv.object_id
123: and pop.report_type_id = prv.report_type_id ---report_type_id will be there for PPR
124: and pop.page_type_code = prv.page_type_code

Line 331: pa_progress_report_vers

327: IS SELECT 'N' FROM
328: dual
329: WHERE exists
330: (SELECT * FROM
331: pa_progress_report_vers
332: WHERE page_id = p_page_id
333: AND (report_status_code = 'PROGRESS_REPORT_PUBLISHED' OR
334: report_status_code = 'PROGRESS_REPORT_SUBMITTED' OR
335: report_status_code = 'PROGRESS_REPORT_APPROVED'));

Line 531: FROM pa_progress_report_vers

527: IS SELECT 'Y'
528: FROM dual
529: WHERE exists(
530: SELECT version_id
531: FROM pa_progress_report_vers
532: WHERE object_id = p_object_id
533: AND object_type = p_object_type
534: );
535:

Line 853: FROM PA_PROGRESS_REPORT_VERS

849: from dual
850: where exists
851: (
852: select version_id
853: FROM PA_PROGRESS_REPORT_VERS
854: WHERE Object_Id = p_object_id
855: AND Object_Type = p_object_type
856: AND report_Type_id = p_report_Type_id ); --- report_Type_id will be there
857: --------- AND Report_Status_Code <> 'PROGRESS_REPORT_PUBLISHED'

Line 895: FROM PA_PROGRESS_REPORT_VERS

891: from dual
892: where exists
893: (
894: select version_id
895: FROM PA_PROGRESS_REPORT_VERS
896: WHERE Object_Id = p_object_id
897: AND Object_Type = p_object_type
898: AND report_Type_id = p_report_Type_id
899: AND Report_Status_Code <> 'PROGRESS_REPORT_PUBLISHED'

Line 1121: from pa_progress_report_vers

1117: l_version_id number;
1118: BEGIN
1119: select version_id
1120: into l_version_id
1121: from pa_progress_report_vers
1122: where object_id = p_object_id
1123: and object_Type = p_object_Type
1124: and report_Type_id = p_report_Type_id
1125: and report_status_code = 'PROGRESS_REPORT_WORKING'

Line 1127: from pa_progress_report_vers

1123: and object_Type = p_object_Type
1124: and report_Type_id = p_report_Type_id
1125: and report_status_code = 'PROGRESS_REPORT_WORKING'
1126: and (report_end_date, last_update_date) = (select max(report_end_Date), max(last_update_date)
1127: from pa_progress_report_vers
1128: where object_id = p_object_id
1129: and object_Type = p_object_Type
1130: and report_Type_id = p_report_Type_id
1131: and report_status_code = 'PROGRESS_REPORT_WORKING');