APPS.PA_ALLOC_RUN dependencies on PA_ALLOC_RULES_ALL

Line 15: G_rule_name PA_ALLOC_RULES_ALL.rule_name%TYPE ;

11: G_denom_currency_code VARCHAR2(15);
12: G_lock_name VARCHAR2(20):= NULL;
13: G_rule_id NUMBER ;
14: G_run_id NUMBER ;
15: G_rule_name PA_ALLOC_RULES_ALL.rule_name%TYPE ;
16: G_request_id NUMBER ;
17: /* Bug No:- 2487147, UTF8 change : changed G_tgt_expnd_org to %TYPE */
18: /* G_tgt_expnd_org VARCHAR2(60); */
19: G_tgt_expnd_org hr_organization_units.name%TYPE;

Line 28: G_basis_balance_category PA_ALLOC_RULES_ALL.basis_balance_category%TYPE; /* added bug 2619977 */

24: G_offset_expnd_org hr_organization_units.name%TYPE;
25: G_offset_expnd_type_class VARCHAR2(30);
26: G_offset_expnd_type VARCHAR2(30);
27: G_num_txns NUMBER := 0 ;
28: G_basis_balance_category PA_ALLOC_RULES_ALL.basis_balance_category%TYPE; /* added bug 2619977 */
29: G_basis_budget_type_code PA_ALLOC_RULES_ALL.basis_budget_type_code%TYPE; /* added bug 2619977 */
30: G_basis_fin_plan_type_id PA_ALLOC_RULES_ALL.basis_fin_plan_type_id%TYPE; /* added bug 2619977 */
31: G_Org_Id Number; /* F
32: /* Cursor Declarations --------------------------------------- */

Line 29: G_basis_budget_type_code PA_ALLOC_RULES_ALL.basis_budget_type_code%TYPE; /* added bug 2619977 */

25: G_offset_expnd_type_class VARCHAR2(30);
26: G_offset_expnd_type VARCHAR2(30);
27: G_num_txns NUMBER := 0 ;
28: G_basis_balance_category PA_ALLOC_RULES_ALL.basis_balance_category%TYPE; /* added bug 2619977 */
29: G_basis_budget_type_code PA_ALLOC_RULES_ALL.basis_budget_type_code%TYPE; /* added bug 2619977 */
30: G_basis_fin_plan_type_id PA_ALLOC_RULES_ALL.basis_fin_plan_type_id%TYPE; /* added bug 2619977 */
31: G_Org_Id Number; /* F
32: /* Cursor Declarations --------------------------------------- */
33: CURSOR C_proj_in_RL (p_project_id IN NUMBER, p_rl_id IN NUMBER , p_resource_struct_type in Varchar2, p_version_id In Number ) IS

Line 30: G_basis_fin_plan_type_id PA_ALLOC_RULES_ALL.basis_fin_plan_type_id%TYPE; /* added bug 2619977 */

26: G_offset_expnd_type VARCHAR2(30);
27: G_num_txns NUMBER := 0 ;
28: G_basis_balance_category PA_ALLOC_RULES_ALL.basis_balance_category%TYPE; /* added bug 2619977 */
29: G_basis_budget_type_code PA_ALLOC_RULES_ALL.basis_budget_type_code%TYPE; /* added bug 2619977 */
30: G_basis_fin_plan_type_id PA_ALLOC_RULES_ALL.basis_fin_plan_type_id%TYPE; /* added bug 2619977 */
31: G_Org_Id Number; /* F
32: /* Cursor Declarations --------------------------------------- */
33: CURSOR C_proj_in_RL (p_project_id IN NUMBER, p_rl_id IN NUMBER , p_resource_struct_type in Varchar2, p_version_id In Number ) IS
34: SELECT 1

Line 115: FROM pa_alloc_rules_all

111: , ALLOC_RESOURCE_STRUCT_TYPE
112: , BASIS_RESOURCE_STRUCT_TYPE
113: , ALLOC_RBS_VERSION
114: , BASIS_RBS_VERSION
115: FROM pa_alloc_rules_all
116: WHERE rule_id = p_rule_id ;
117: cursor c_target_det is
118: select '1'
119: from dual

Line 6167: from pa_alloc_rules_all

6163: ;
6164: /* Added for bug 3227783 */
6165: cursor c_get_rule_pool_percent is
6166: Select nvl(pool_percent,100)/100
6167: from pa_alloc_rules_all
6168: where rule_id = p_rule_id;
6169: /****cursor c_proj_start_date(p_proj_id IN NUMBER) is
6170: select start_date
6171: from pa_projects