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: l_rate_source_code pa_compensation_rule_sets.rate_source_code%TYPE; /* added for 12.2 . bug 10253400 */
62: l_base_hours pa_org_labor_sch_rule.base_hours%TYPE; /* 12.2 payroll intg .. bug 11811475 */
63: l_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE; /* 12.2 payroll intg .. bug 11811475 */

Line 61: l_rate_source_code pa_compensation_rule_sets.rate_source_code%TYPE; /* added for 12.2 . bug 10253400 */

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: l_rate_source_code pa_compensation_rule_sets.rate_source_code%TYPE; /* added for 12.2 . bug 10253400 */
62: l_base_hours pa_org_labor_sch_rule.base_hours%TYPE; /* 12.2 payroll intg .. bug 11811475 */
63: l_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE; /* 12.2 payroll intg .. bug 11811475 */
64: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
65: l_rbc_rate number;

Line 340: from pa_compensation_rule_sets rule

336: The rate source would hold the source of the rates. */
337:
338: select rule.costing_method, rule.rate_source_code
339: into l_costing_method, l_rate_source_code
340: from pa_compensation_rule_sets rule
341: where rule.compensation_rule_set = x_costing_rule
342: ;
343: if ( l_debug_mode = 'Y' ) then
344: pa_cc_utils.log_message('l_costing_method '||l_costing_method);

Line 436: from pa_compensation_rule_sets rule

432: pa_cc_utils.log_message(l_stage);
433:
434: select rule.costing_method, rule.rate_source_code
435: into l_costing_method, l_rate_source_code
436: from pa_compensation_rule_sets rule
437: where rule.compensation_rule_set = x_costing_rule;
438:
439: if ( l_debug_mode = 'Y' ) then
440: pa_cc_utils.log_message('l_costing_method '||l_costing_method);

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

639: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
640: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
641: ,p_calling_module IN varchar2 default 'STAFFED'
642: ,x_org_labor_sch_rule_id IN OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE
643: ,x_costing_rule IN OUT NOCOPY pa_compensation_rule_sets.compensation_rule_set%TYPE
644: ,x_rate_sch_id IN OUT NOCOPY pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE
645: ,x_ot_project_id IN OUT NOCOPY pa_projects_all.project_id%TYPE
646: ,x_ot_task_id IN OUT NOCOPY pa_tasks.task_id%TYPE
647: ,x_base_hours IN OUT NOCOPY pa_org_labor_sch_rule.base_hours%TYPE /* 12.2 payroll intg .. bug 11811475 */

Line 664: l_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;

660: l_stage VARCHAR2(500);
661:
662: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;
663: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE;
664: l_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
665: l_ot_project_id pa_projects_all.project_id%TYPE;
666: l_ot_task_id pa_tasks.task_id%TYPE;
667: l_acct_rate_date_code pa_org_labor_sch_rule.acct_rate_date_code%TYPE;
668: l_acct_rate_type pa_org_labor_sch_rule.acct_rate_type%TYPE;

Line 671: l_costing_method pa_compensation_rule_sets.costing_method%TYPE;

667: l_acct_rate_date_code pa_org_labor_sch_rule.acct_rate_date_code%TYPE;
668: l_acct_rate_type pa_org_labor_sch_rule.acct_rate_type%TYPE;
669: l_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%TYPE;
670:
671: l_costing_method pa_compensation_rule_sets.costing_method%TYPE;
672: l_rate_source_code pa_compensation_rule_sets.rate_source_code%TYPE;
673: l_base_hours pa_org_labor_sch_rule.base_hours%TYPE;
674: l_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE;
675:

Line 672: l_rate_source_code pa_compensation_rule_sets.rate_source_code%TYPE;

668: l_acct_rate_type pa_org_labor_sch_rule.acct_rate_type%TYPE;
669: l_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%TYPE;
670:
671: l_costing_method pa_compensation_rule_sets.costing_method%TYPE;
672: l_rate_source_code pa_compensation_rule_sets.rate_source_code%TYPE;
673: l_base_hours pa_org_labor_sch_rule.base_hours%TYPE;
674: l_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE;
675:
676: cursor org_costing_rule( p_org_id IN pa_implementations_all.org_id%TYPE

Line 827: from pa_compensation_rule_sets

823: if org_costing_rule%FOUND then
824: begin
825: select costing_method, rate_source_code
826: into l_costing_method, l_rate_source_code
827: from pa_compensation_rule_sets
828: where compensation_rule_set = l_costing_rule;
829: exception
830: when no_data_found then
831: l_rate_source_code := NULL;