APPS.PA_BILL_PCT dependencies on PA_PERCENT_COMPLETES_FIN_V

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

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

Line 1062: FROM PA_PERCENT_COMPLETES_FIN_V ppc

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

Line 1069: from PA_PERCENT_COMPLETES_FIN_V

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

Line 1080: FROM PA_PERCENT_COMPLETES_FIN_V ppc

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

Line 1086: from PA_PERCENT_COMPLETES_FIN_V ppcx

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

Line 1091: from PA_PERCENT_COMPLETES_FIN_V ppcy

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