eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_COST_RATE_PUB dependencies on PA_ORG_LABOR_SCH_RULE

Line 32: ,x_org_labor_sch_rule_id OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE

28: ,x_organization_id IN OUT NOCOPY pa_expenditures_all.incurred_by_organization_id%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

Line 38: ,x_acct_exch_rate OUT NOCOPY pa_org_labor_sch_rule.acct_exchange_rate%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
38: ,x_acct_exch_rate OUT NOCOPY pa_org_labor_sch_rule.acct_exchange_rate%TYPE
39: ,x_ot_project_id OUT NOCOPY pa_projects_all.project_id%TYPE
40: ,x_ot_task_id OUT NOCOPY pa_tasks.task_id%TYPE
41: ,x_err_stage OUT NOCOPY number
42: ,x_err_code OUT NOCOPY varchar2

Line 62: l_base_hours pa_org_labor_sch_rule.base_hours%TYPE; /* 12.2 payroll intg .. bug 11811475 */

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;
66:

Line 63: l_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE; /* 12.2 payroll intg .. bug 11811475 */

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;
66:
67: begin

Line 642: ,x_org_labor_sch_rule_id IN OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE

638: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%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

Line 647: ,x_base_hours IN OUT NOCOPY pa_org_labor_sch_rule.base_hours%TYPE /* 12.2 payroll intg .. bug 11811475 */

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 */
648: ,x_rbc_elem_type_id IN OUT NOCOPY pa_org_labor_sch_rule.rbc_element_type_id%TYPE
649: ,x_cost_rate_curr_code IN OUT NOCOPY pa_expenditure_items_all.denom_currency_code%TYPE
650: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
651: ,x_acct_rate_date_code IN OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE

Line 648: ,x_rbc_elem_type_id IN OUT NOCOPY pa_org_labor_sch_rule.rbc_element_type_id%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 */
648: ,x_rbc_elem_type_id IN OUT NOCOPY pa_org_labor_sch_rule.rbc_element_type_id%TYPE
649: ,x_cost_rate_curr_code IN OUT NOCOPY pa_expenditure_items_all.denom_currency_code%TYPE
650: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
651: ,x_acct_rate_date_code IN OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE
652: ,x_acct_exch_rate IN OUT NOCOPY pa_compensation_details_all.acct_exchange_rate%TYPE

Line 662: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;

658:
659: l_debug_mode VARCHAR2(1) := 'Y';
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;

Line 667: l_acct_rate_date_code pa_org_labor_sch_rule.acct_rate_date_code%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;
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;

Line 668: l_acct_rate_type pa_org_labor_sch_rule.acct_rate_type%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;
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;

Line 669: l_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%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;
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;

Line 673: l_base_hours pa_org_labor_sch_rule.base_hours%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
677: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE

Line 674: l_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%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
677: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
678: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE

Line 695: from pa_org_labor_sch_rule assign

691: ,assign.acct_rate_type
692: ,assign.acct_exchange_rate
693: ,assign.base_hours
694: ,assign.rbc_element_type_id
695: from pa_org_labor_sch_rule assign
696: ,pa_org_hierarchy_denorm hier
697: ,pa_implementations imp
698: where hier.child_organization_id = p_organization_id
699: and imp.exp_org_structure_version_id=hier.org_hierarchy_version_id

Line 726: from pa_org_labor_sch_rule assign

722: ,assign.acct_rate_type
723: ,assign.acct_exchange_rate
724: ,assign.base_hours
725: ,assign.rbc_element_type_id
726: from pa_org_labor_sch_rule assign
727: ,pa_org_hierarchy_denorm hier
728: ,pa_implementations imp
729: where hier.child_organization_id = p_organization_id
730: and imp.exp_org_structure_version_id=hier.org_hierarchy_version_id

Line 929: from pa_org_labor_sch_rule assign

925: ,g_ou_acct_rate_type
926: ,g_ou_acct_exch_rate
927: ,g_base_hours
928: ,g_rbc_elem_type_id
929: from pa_org_labor_sch_rule assign
930: where assign.organization_id is null
931: and trunc(p_txn_date) between trunc(assign.start_date_active)
932: and trunc(nvl(assign.end_date_active,p_txn_date))
933: and nvl(assign.org_id,-99) = nvl(p_org_id, -99);

Line 1059: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;

1055: l_cost_rate pa_bill_rates_all.rate%type;
1056: l_acct_cost_rate pa_bill_rates_all.rate%type;
1057: l_start_date_active date;
1058: l_end_date_active date;
1059: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;
1060: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;
1061: l_override_type pa_compensation_details.override_type%type;
1062: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
1063: l_acct_rate_type pa_compensation_details.acct_rate_type%type;

Line 1229: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;

1225: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;
1226: l_cost_rate pa_bill_rates_all.rate%type;
1227: l_start_date_active date;
1228: l_end_date_active date;
1229: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;
1230: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;
1231: l_override_type pa_compensation_details.override_type%type;
1232: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
1233: l_acct_rate_type pa_compensation_details.acct_rate_type%type;