DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_LOOKUPS

Line 9427: FROM pa_lookups

9423: where expenditure_group in (v_tgt_exp_group,v_off_exp_group) ;
9424: --Get the the rule name for capitalized interest
9425: Cursor C_cint_rule_name IS
9426: SELECT meaning
9427: FROM pa_lookups
9428: WHERE lookup_type='PROJECT_STATUS_ACTIONS'
9429: AND lookup_code='CAPITALIZED_INTEREST';
9430:
9431: /* added cursor for bug 6243121 */

Line 9440: l_transaction_source pa_lookups.meaning%TYPE;

9436: and status_code='R'
9437: and rejection_code is not null;
9438:
9439: --Declared this variable for Capital project Changes
9440: l_transaction_source pa_lookups.meaning%TYPE;
9441: BEGIN
9442: pa_debug.set_err_stack('Release_alloc_txns') ;
9443: pa_debug.G_err_stage := 'Release_alloc_txns' ;
9444: IF P_DEBUG_MODE = 'Y' THEN