DBA Data[Home] [Help]

APPS.PA_CC_IDENT dependencies on PA_EXPENDITURES

Line 620: pa_expenditures exp

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
624: and exp_item.transaction_source = NVL(c_transaction_source, exp_item.transaction_source); -- added bug 14173646

Line 1135: pa_expenditures exp

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
1139: and exp_item.transaction_source = NVL(c_transaction_source, exp_item.transaction_source); -- added bug 14173646;

Line 1742: p_organization_id PA_EXPENDITURES_ALL.INCURRED_BY_ORGANIZATION_ID%TYPE)

1738: -- = Output parameter:
1739: -- = Legal entity id of data type NUMBER
1740: -- ==========================================================================
1741: FUNCTION GET_ORG_LEGAL_ENTITY( p_org_id NUMBER,
1742: p_organization_id PA_EXPENDITURES_ALL.INCURRED_BY_ORGANIZATION_ID%TYPE)
1743: RETURN NUMBER IS
1744:
1745: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;
1746: