11:
12: CURSOR C_Period
13: IS
14: SELECT DISTINCT a.period_type
15: FROM pa_alloc_rules_all a,
16: gl_auto_alloc_batches b
17: WHERE b.allocation_set_id = p_allocation_set_id
18: AND b.batch_type_code = 'P'
19: AND a.rule_id = b.batch_id;
107:
108: /** Find out the run_period (pa/gl period) to be passed **/
109: select period_type, org_id -- Fix for bug : 4640479
110: into v_period_type , l_org_id
111: from pa_alloc_rules_all
112: where rule_id = p_rule_id;
113:
114: /* dbms_output.put_line('Period Type = '||v_period_type); */
115: