DBA Data[Home] [Help]

APPS.PA_CAP_INT_PVT dependencies on PA_CINT_SOURCE_DETAILS

Line 2671: INSERT INTO pa_cint_source_details

2667: FOR k IN lt_task_id.FIRST..lt_task_id.LAST LOOP
2668:
2669: IF lt_process_task_flag(k) = 'Y' THEN
2670:
2671: INSERT INTO pa_cint_source_details
2672: (alloc_txn_id
2673: ,run_period_end_date
2674: ,project_id
2675: ,expenditure_item_id

Line 3041: DELETE FROM pa_cint_source_details pcsd

3037:
3038: -- Delete rows in specified increments until no rows remain to be deleted
3039: LOOP
3040: BEGIN
3041: DELETE FROM pa_cint_source_details pcsd
3042: WHERE pcsd.run_period_end_date <= ld_period_end_date
3043: AND EXISTS
3044: (SELECT pp.project_id
3045: FROM pa_projects pp