APPS.PA_UTILS dependencies on PA_COMPENSATION_RULE_SETS

Line 2190: from pa_compensation_rule_sets rule

2186: if l_costing_rule_tab(1) is not null then
2187:
2188: select rule.costing_method, rule.rate_source_code,rule.enable_accrual_code
2189: into x_costing_method, x_rate_source_code,x_enable_accrual
2190: from pa_compensation_rule_sets rule
2191: where rule.compensation_rule_set = l_costing_rule_tab(1);
2192:
2193: end if;
2194:

Line 2244: l_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;

2240: and ei.po_line_id IS NULL;
2241:
2242: l_calling_module varchar2(50) default 'STAFFED';
2243: l_Called_From varchar2(1) DEFAULT 'O';
2244: l_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
2245:
2246: l_debug_mode varchar2(1);
2247:
2248: l_org_id pa_implementations_all.org_id%TYPE;

Line 2256: lx_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;

2252: l_txn_date pa_expenditure_items_all.expenditure_item_date%TYPE;
2253:
2254: lx_override_type varchar2(150);
2255: lx_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;
2256: lx_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
2257: lx_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE;
2258: lx_ot_project_id pa_projects_all.project_id%TYPE;
2259: lx_ot_task_id pa_tasks.task_id%TYPE;
2260: lx_base_hours pa_org_labor_sch_rule.base_hours%TYPE;

Line 2327: from pa_compensation_rule_sets rule

2323: if lx_costing_rule IS NOT NULL then
2324:
2325: select rule.costing_method, rule.rate_source_code,rule.enable_accrual_code
2326: into x_costing_method, x_rate_source_code,x_enable_accrual
2327: from pa_compensation_rule_sets rule
2328: where rule.compensation_rule_set = lx_costing_rule;
2329:
2330: end if;
2331:

Line 2375: l_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;

2371:
2372:
2373: l_calling_module varchar2(50) default 'STAFFED';
2374: l_Called_From varchar2(1) DEFAULT 'O';
2375: l_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
2376:
2377: l_debug_mode varchar2(1);
2378:
2379: l_org_id pa_implementations_all.org_id%TYPE;

Line 2387: lx_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;

2383: l_txn_date pa_expenditure_items_all.expenditure_item_date%TYPE;
2384:
2385: lx_override_type varchar2(150);
2386: lx_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;
2387: lx_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
2388: lx_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE;
2389: lx_ot_project_id pa_projects_all.project_id%TYPE;
2390: lx_ot_task_id pa_tasks.task_id%TYPE;
2391: lx_base_hours pa_org_labor_sch_rule.base_hours%TYPE;

Line 2458: from pa_compensation_rule_sets rule

2454: if lx_costing_rule IS NOT NULL then
2455:
2456: select rule.costing_method, rule.rate_source_code,rule.enable_accrual_code
2457: into x_costing_method, x_rate_source_code,x_enable_accrual
2458: from pa_compensation_rule_sets rule
2459: where rule.compensation_rule_set = lx_costing_rule;
2460:
2461: end if;
2462: