APPS.PA_BILL_PCT dependencies on PA_PERCENT_COMPLETES_FIN_V

Line 1056: Using the view PA_PERCENT_COMPLETES_FIN_V instead of pa_percent_completes */

1052:
1053: -- Cursor to select the most recently entered completion percentage
1054: --
1055: /* Patchset K : Percent complete changes :
1056: Using the view PA_PERCENT_COMPLETES_FIN_V instead of pa_percent_completes */
1057:
1058:
1059: /* Changed cursor to pickup record based on sequence number (percent_complete_id)
1060: for bug no 1283352.

Line 1064: FROM PA_PERCENT_COMPLETES_FIN_V ppc

1060: for bug no 1283352.
1061:
1062: CURSOR pct IS
1063: SELECT NVL(completed_percentage,0)
1064: FROM PA_PERCENT_COMPLETES_FIN_V ppc
1065: WHERE
1066: ppc.project_id = X2_project_id AND
1067: nvl(ppc.task_id,0) = nvl(X2_task_id,0 )
1068: AND ppc.date_computed

Line 1071: from PA_PERCENT_COMPLETES_FIN_V

1067: nvl(ppc.task_id,0) = nvl(X2_task_id,0 )
1068: AND ppc.date_computed
1069: =
1070: (SELECT max(date_computed)
1071: from PA_PERCENT_COMPLETES_FIN_V
1072: where date_computed <= nvl(X2_accrue_through_date, sysdate)
1073: and project_id = X2_project_id
1074: and nvl(task_id,0) = nvl(X2_task_id,0)
1075: )

Line 1082: FROM PA_PERCENT_COMPLETES_FIN_V ppc

1078: bug fix 1283352 "commentation" ends. */
1079:
1080: CURSOR pct IS
1081: SELECT NVL(completed_percentage,0)
1082: FROM PA_PERCENT_COMPLETES_FIN_V ppc
1083: WHERE
1084: ppc.project_id = X2_project_id
1085: And nvl(ppc.task_id,0) = nvl(X2_task_id,0 )
1086: And ppc.date_computed <= nvl(X2_accrue_through_date, sysdate)

Line 1088: from PA_PERCENT_COMPLETES_FIN_V ppcx

1084: ppc.project_id = X2_project_id
1085: And nvl(ppc.task_id,0) = nvl(X2_task_id,0 )
1086: And ppc.date_computed <= nvl(X2_accrue_through_date, sysdate)
1087: And ppc.percent_complete_id = ( Select max(ppcx.percent_complete_id)
1088: from PA_PERCENT_COMPLETES_FIN_V ppcx
1089: where project_id = X2_project_id
1090: and nvl(task_id,0) = nvl(X2_task_id,0)
1091: and ppcx.date_computed = (
1092: Select max(ppcy.date_computed)

Line 1093: from PA_PERCENT_COMPLETES_FIN_V ppcy

1089: where project_id = X2_project_id
1090: and nvl(task_id,0) = nvl(X2_task_id,0)
1091: and ppcx.date_computed = (
1092: Select max(ppcy.date_computed)
1093: from PA_PERCENT_COMPLETES_FIN_V ppcy
1094: Where ppcy.date_computed <= nvl(X2_accrue_through_date, sysdate)
1095: and ppcy.project_id = X2_project_id
1096: and nvl(ppcy.task_id,0) = nvl(X2_task_id,0)));
1097: BEGIN