APPS.PA_COST_RATE_PUB dependencies on PA_COMPENSATION_RULE_SETS

Line 33: ,x_costing_rule OUT NOCOPY pa_compensation_rule_sets.compensation_rule_set%TYPE

29: ,x_cost_rate OUT NOCOPY pa_bill_rates_all.rate%TYPE
30: ,x_start_date_active OUT NOCOPY date
31: ,x_end_date_active OUT NOCOPY date
32: ,x_org_labor_sch_rule_id OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE
33: ,x_costing_rule OUT NOCOPY pa_compensation_rule_sets.compensation_rule_set%TYPE
34: ,x_rate_sch_id OUT NOCOPY pa_std_bill_rate_schedules_all.bill_rate_sch_id%TYPE
35: ,x_cost_rate_curr_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE
36: ,x_acct_rate_type OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
37: ,x_acct_rate_date_code OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE

Line 59: l_costing_method pa_compensation_rule_sets.costing_method%TYPE;

55: l_override_type pa_compensation_details.override_type%TYPE;
56: l_sch_type pa_std_bill_rate_schedules_all.schedule_type%TYPE;
57: l_job_group_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;
58: l_dest_job_id pa_bill_rates_all.job_id%TYPE;
59: l_costing_method pa_compensation_rule_sets.costing_method%TYPE;
60: l_curr_org_id pa_expenditures_all.org_id%TYPE; /* Added for bug 7365397 */
61:
62: begin
63:

Line 309: from pa_compensation_rule_sets rule

305: pa_cc_utils.log_message(l_stage);
306: end if;
307: select rule.costing_method
308: into l_costing_method
309: from pa_compensation_rule_sets rule
310: where rule.compensation_rule_set = x_costing_rule
311: ;
312: if ( l_costing_method = 'LABOR_COST_EXTN' )
313: then

Line 389: from pa_compensation_rule_sets rule

385: l_stage := 'selecting costing method from rule [' || x_costing_rule || ']';
386: pa_cc_utils.log_message(l_stage);
387: select rule.costing_method
388: into l_costing_method
389: from pa_compensation_rule_sets rule
390: where rule.compensation_rule_set = x_costing_rule
391: ;
392: if ( l_costing_method = 'LABOR_COST_EXTN' )
393: then

Line 527: ,x_costing_rule IN OUT NOCOPY pa_compensation_rule_sets.compensation_rule_set%TYPE

523: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
524: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
525: ,p_calling_module IN varchar2 default 'STAFFED'
526: ,x_org_labor_sch_rule_id IN OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE
527: ,x_costing_rule IN OUT NOCOPY pa_compensation_rule_sets.compensation_rule_set%TYPE
528: ,x_rate_sch_id IN OUT NOCOPY pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE
529: ,x_ot_project_id IN OUT NOCOPY pa_projects_all.project_id%TYPE
530: ,x_ot_task_id IN OUT NOCOPY pa_tasks.task_id%TYPE
531: ,x_cost_rate_curr_code IN OUT NOCOPY pa_expenditure_items_all.denom_currency_code%TYPE

Line 546: l_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;

542: l_stage VARCHAR2(500);
543:
544: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;
545: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE;
546: l_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
547: l_ot_project_id pa_projects_all.project_id%TYPE;
548: l_ot_task_id pa_tasks.task_id%TYPE;
549: l_acct_rate_date_code pa_org_labor_sch_rule.acct_rate_date_code%TYPE;
550: l_acct_rate_type pa_org_labor_sch_rule.acct_rate_type%TYPE;