DBA Data[Home] [Help]

APPS.PA_GL_AUTOALLOC_PKG dependencies on PA_ALLOC_RULES_ALL

Line 15: FROM pa_alloc_rules_all a,

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;

Line 111: from pa_alloc_rules_all

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: