DBA Data[Home] [Help]

APPS.PA_CC_IDENT dependencies on PA_EXPENDITURE_GROUPS

Line 619: pa_expenditure_groups grp ,

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
623: and exp.expenditure_group = grp.expenditure_group

Line 1134: pa_expenditure_groups grp ,

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
1138: and exp.expenditure_group = grp.expenditure_group