APPS.PA_FP_GEN_BILLING_AMOUNTS dependencies on GL_PERIOD_STATUSES

Line 421: c_appl_id GL_PERIOD_STATUSES.APPLICATION_ID%TYPE,

417: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BILLING_AMOUNTS.GEN_BILLING_AMOUNTS';
418:
419: --Cursor used to sum the revenue amount
420: CURSOR SUM_BILL_CRSR(c_tphase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE,
421: c_appl_id GL_PERIOD_STATUSES.APPLICATION_ID%TYPE,
422: c_set_of_books_id PA_IMPLEMENTATIONS_ALL.SET_OF_BOOKS_ID%TYPE,
423: c_org_id PA_PROJECTS_ALL.ORG_ID%TYPE,
424: c_multi_flag PA_PROJ_FP_OPTIONS.PLAN_IN_MULTI_CURR_FLAG%TYPE,
425: c_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,

Line 471: GL_PERIOD_STATUSES GLP

467: FROM PA_EVENTS_DELIVERABLE_V V,
468: PA_EVENT_TYPES ET,
469: PA_RES_LIST_MAP_TMP4 TMP,
470: PA_RESOURCE_ASSIGNMENTS P,
471: GL_PERIOD_STATUSES GLP
472: WHERE TMP.TXN_SOURCE_ID = V.EVENT_ID
473: AND V.EVENT_TYPE = ET.EVENT_TYPE
474: AND V.PROJECT_ID = P_PROJECT_ID
475: AND P.RESOURCE_ASSIGNMENT_ID = TMP.TXN_RESOURCE_ASSIGNMENT_ID