DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_LOOKUPS

Line 9322: FROM pa_lookups

9318: where expenditure_group in (v_tgt_exp_group,v_off_exp_group) ;
9319: --Get the the rule name for capitalized interest
9320: Cursor C_cint_rule_name IS
9321: SELECT meaning
9322: FROM pa_lookups
9323: WHERE lookup_type='PROJECT_STATUS_ACTIONS'
9324: AND lookup_code='CAPITALIZED_INTEREST';
9325:
9326: /* added cursor for bug 6243121 */

Line 9335: l_transaction_source pa_lookups.meaning%TYPE;

9331: and status_code='R'
9332: and rejection_code is not null;
9333:
9334: --Declared this variable for Capital project Changes
9335: l_transaction_source pa_lookups.meaning%TYPE;
9336: BEGIN
9337: pa_debug.set_err_stack('Release_alloc_txns') ;
9338: pa_debug.G_err_stage := 'Release_alloc_txns' ;
9339: IF P_DEBUG_MODE = 'Y' THEN