APPS.PA_CC_IDENT dependencies on PA_EXPENDITURE_ITEMS

Line 618: FROM PA_EXPENDITURE_ITEMS exp_item,

614: /* added as part of bug 12974801 */
615:
616: CURSOR GetAdjExpid( c_exp_item_id number, c_transaction_source varchar2) IS
617: SELECT distinct ADJUSTED_EXPENDITURE_ITEM_ID ,period_accrual_flag
618: FROM PA_EXPENDITURE_ITEMS exp_item,
619: pa_expenditure_groups grp ,
620: pa_expenditures exp
621: WHERE exp_item.EXPENDITURE_ITEM_ID =c_exp_item_id
622: and exp_item.expenditure_id =exp.expenditure_id

Line 890: UPDATE pa_expenditure_items_all

886: WHEN NO_DATA_FOUND THEN
887: IF P_DEBUG_MODE THEN
888: pa_cc_utils.log_message('PA_CC_GET_PRVDR_RECVR_ORGS: ' || '20.10.115: Setting the rejection code to INV_DATA when no data found');
889: END IF;
890: UPDATE pa_expenditure_items_all
891: SET cost_dist_rejection_code = 'INV_DATA'
892: WHERE task_id = P_TaskIdTab(j)
893: AND cost_distributed_flag = 'S'
894: AND cost_dist_rejection_code is null;

Line 1133: FROM PA_EXPENDITURE_ITEMS exp_item,

1129: l_period_accrual_flag varchar2(5);
1130:
1131: CURSOR GetAdjExpid( c_exp_item_id number, c_transaction_source varchar2) IS
1132: SELECT distinct ADJUSTED_EXPENDITURE_ITEM_ID ,period_accrual_flag
1133: FROM PA_EXPENDITURE_ITEMS exp_item,
1134: pa_expenditure_groups grp ,
1135: pa_expenditures exp
1136: WHERE exp_item.EXPENDITURE_ITEM_ID =c_exp_item_id
1137: and exp_item.expenditure_id =exp.expenditure_id