DBA Data[Home] [Help]

APPS.PA_FP_EDIT_LINE_PKG dependencies on PA_FP_ROLLUP_TMP_S

Line 798: SELECT pa_fp_rollup_tmp_s.nextval

794: ,PROJFUNC_REV_EXCHANGE_RATE
795: ,PROJFUNC_REV_RATE_DATE_TYPE
796: ,PROJFUNC_REV_RATE_DATE
797: )
798: SELECT pa_fp_rollup_tmp_s.nextval
799: ,p_resource_assignment_id
800: ,NULL /* BUDGET_LINE_ID */
801: ,NULL
802: ,NULL

Line 1217: SELECT PA_FP_ROLLUP_TMP_S.NEXTVAL

1213: ,REVENUE_SOURCE
1214: ,PM_PRODUCT_CODE
1215: )
1216: (
1217: SELECT PA_FP_ROLLUP_TMP_S.NEXTVAL
1218: ,P_RESOURCE_ASSIGNMENT_ID
1219: ,pbl.BUDGET_LINE_ID
1220: ,pbl.START_DATE OLD_START_DATE /* when old_start_Date is null then the record should be inserted in pbl */
1221: ,tmp.START_DATE START_DATE

Line 1483: SELECT pa_fp_rollup_tmp_s.nextval

1479: ,REVENUE_SOURCE
1480: ,PM_PRODUCT_CODE
1481: )
1482: (
1483: SELECT pa_fp_rollup_tmp_s.nextval
1484: ,p_resource_assignment_id /* Fix for bug # 2586514 */
1485: ,pbl.BUDGET_LINE_ID
1486: ,pbl.start_date OLD_START_DATE /* when old_start_Date is null then the record should be inserted in pbl */
1487: ,nvl(pbl.start_date,l_start_date)