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_FP_GEN_BUDGET_AMT_PUB dependencies on PA_PERIODS_ALL

Line 924: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,

920: P_CALLED_MODE IN VARCHAR2,
921: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
922: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
923: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
924: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
925: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
926: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
927: --this pl/sql table is used to update the initial res_asg_id from the generated amounts
928: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,

Line 1027: /* Bug 5657334: Added org_id join in pa_periods_all to avoid multiple row selection */

1023: AND PA.ASSIGNMENT_ID = FI.ASSIGNMENT_ID
1024: AND FI.DELETE_FLAG = 'N' -- Added for Bug 5029939
1025: AND FI.ERROR_FLAG = 'N'; -- Added for Bug 5029939
1026:
1027: /* Bug 5657334: Added org_id join in pa_periods_all to avoid multiple row selection */
1028: CURSOR FCST_PA(p_prj_assignment_id NUMBER, c_act_thru_date DATE, c_exp_organization_id NUMBER, c_org_id NUMBER) IS
1029: SELECT FI.EXPENDITURE_ORG_ID,
1030: FI.EXPENDITURE_ORGANIZATION_ID,
1031: FI.RCVR_PA_PERIOD_NAME,

Line 1038: PA_PERIODS_ALL P

1034: SUM(FI.ITEM_QUANTITY),
1035: MIN(FI.FORECAST_ITEM_ID)
1036: FROM PA_FORECAST_ITEMS FI,
1037: PA_FORECAST_ITEM_DETAILS FID,
1038: PA_PERIODS_ALL P
1039: WHERE FI.PROJECT_ORG_ID = NVL(P.ORG_ID,-99)
1040: AND P.ORG_ID = c_org_id /* Bug 5657334 */
1041: AND P.PERIOD_NAME = FI.RCVR_PA_PERIOD_NAME
1042: AND FI.FORECAST_ITEM_ID = FID.FORECAST_ITEM_ID

Line 1124: /* Bug 5657334: Added org_id join in pa_periods_all to avoid multiple row selection */

1120:
1121: -- M-Closeout: Bill Rate Override ER ------------------------------------------
1122: -- Also query up the rate API parameters per period
1123:
1124: /* Bug 5657334: Added org_id join in pa_periods_all to avoid multiple row selection */
1125: CURSOR FCST_RATE_PA(p_prj_assignment_id NUMBER, c_act_thru_date DATE, c_exp_organization_id NUMBER, c_org_id NUMBER) IS
1126: SELECT FI.EXPENDITURE_ORG_ID,
1127: FI.EXPENDITURE_ORGANIZATION_ID,
1128: FI.RCVR_PA_PERIOD_NAME,

Line 1155: PA_PERIODS_ALL P,

1151: RLM.RESOURCE_LIST_ID,
1152: RLM.ALIAS
1153: FROM PA_FORECAST_ITEMS FI,
1154: PA_FORECAST_ITEM_DETAILS FID,
1155: PA_PERIODS_ALL P,
1156: PA_RES_LIST_MAP_TMP4 TMP4,
1157: PA_RESOURCE_ASSIGNMENTS RA,
1158: PA_RESOURCE_LIST_MEMBERS RLM
1159: WHERE FI.PROJECT_ORG_ID = NVL(P.ORG_ID,-99)

Line 6820: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,

6816: P_CALLED_MODE IN VARCHAR2,
6817: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
6818: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
6819: P_INC_OPEN_COMMIT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
6820: P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
6821: P_CI_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
6822: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
6823: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
6824: P_COMMIT_FLAG IN VARCHAR2,