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_COMPENSATION_DETAILS

Line 55: l_override_type pa_compensation_details.override_type%TYPE;

51: l_use_cache varchar2(1);
52: l_num_dummy pa_expenditure_items_all.expenditure_item_id%TYPE;
53:
54: l_override_flag varchar2(1) := 'N' ;
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;

Line 277: from pa_compensation_details_all detail /2879644:Added ALL/

273: ,x_acct_exch_rate
274: ,x_start_date_active
275: ,x_end_date_active
276: ,l_rbc_elem_type_id
277: from pa_compensation_details_all detail /*2879644:Added ALL*/
278: where trunc(p_txn_date) between trunc(detail.start_date_active)
279: and trunc(nvl(detail.end_date_active,p_txn_date))
280: and NVL(detail.org_id,-99) = NVL(NVL(p_org_id, g_ou_id),-99) /*2879644 :Added org_id join 7158405 */
281: and detail.person_id = p_person_id;

Line 652: ,x_acct_exch_rate IN OUT NOCOPY pa_compensation_details_all.acct_exchange_rate%TYPE

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
653: ,x_err_stage IN OUT NOCOPY number
654: ,x_err_code IN OUT NOCOPY varchar2
655: ,P_Called_From IN varchar2 DEFAULT 'O' /* Added for 3405326 */
656: )

Line 1054: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;

1050: RETURN pa_bill_rates_all.rate%type IS
1051: l_job_id pa_expenditure_items_all.job_id%type;
1052: l_organization_id pa_expenditures_all.incurred_by_organization_id%type;
1053: l_org_id pa_expenditures_all.org_id%type; /*2879644*/
1054: l_costing_rule pa_compensation_details_all.compensation_rule_set%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;

Line 1061: l_override_type pa_compensation_details.override_type%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;
1064: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
1065: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;

Line 1062: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;

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;
1064: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
1065: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
1066: l_ot_project_id pa_projects_all.project_id%type;

Line 1063: l_acct_rate_type pa_compensation_details.acct_rate_type%type;

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;
1064: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
1065: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
1066: l_ot_project_id pa_projects_all.project_id%type;
1067: l_ot_task_id pa_tasks.task_id%type;

Line 1064: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%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;
1064: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
1065: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
1066: l_ot_project_id pa_projects_all.project_id%type;
1067: l_ot_task_id pa_tasks.task_id%type;
1068: l_err_code varchar2(200) default null; /* Default null added for bug 2931397 */

Line 1065: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%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;
1064: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
1065: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
1066: l_ot_project_id pa_projects_all.project_id%type;
1067: l_ot_task_id pa_tasks.task_id%type;
1068: l_err_code varchar2(200) default null; /* Default null added for bug 2931397 */
1069: l_err_stage number;

Line 1225: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;

1221: RETURN VARCHAR2 IS
1222: l_job_id pa_expenditure_items_all.job_id%type;
1223: l_organization_id pa_expenditures_all.incurred_by_organization_id%type;
1224: l_org_id pa_expenditures_all.org_id%TYPE ; /*2879644*/
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;

Line 1231: l_override_type pa_compensation_details.override_type%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;
1234: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
1235: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;

Line 1232: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;

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;
1234: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
1235: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
1236: l_ot_project_id pa_projects_all.project_id%type;

Line 1233: l_acct_rate_type pa_compensation_details.acct_rate_type%type;

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;
1234: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
1235: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
1236: l_ot_project_id pa_projects_all.project_id%type;
1237: l_ot_task_id pa_tasks.task_id%type;

Line 1234: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%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;
1234: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
1235: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
1236: l_ot_project_id pa_projects_all.project_id%type;
1237: l_ot_task_id pa_tasks.task_id%type;
1238: l_err_code varchar2(200);

Line 1235: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%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;
1234: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
1235: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
1236: l_ot_project_id pa_projects_all.project_id%type;
1237: l_ot_task_id pa_tasks.task_id%type;
1238: l_err_code varchar2(200);
1239: l_err_stage number;