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_BILL_RATES_ALL

Line 29: ,x_cost_rate OUT NOCOPY pa_bill_rates_all.rate%TYPE

25: ,p_calling_module IN varchar2 default 'STAFFED'
26: ,p_org_id IN pa_expenditures_all.org_id%TYPE default NULL /*2879644*/
27: ,x_job_id IN OUT NOCOPY pa_expenditure_items_all.job_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

Line 58: l_dest_job_id pa_bill_rates_all.job_id%TYPE;

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;
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 */

Line 524: from pa_bill_rates_all bill_rates

520: ,bill_rates.end_date_active
521: into x_cost_rate
522: ,x_start_date_active
523: ,x_end_date_active
524: from pa_bill_rates_all bill_rates
525: where trunc(p_txn_date) between trunc(bill_rates.start_date_active)
526: and trunc(nvl(bill_rates.end_date_active,p_txn_date))
527: and bill_rates.person_id = p_person_id
528: and bill_rates.bill_rate_sch_id = x_rate_sch_id

Line 554: from pa_bill_rates_all bill_rates

550: ,bill_rates.end_date_active
551: into x_cost_rate
552: ,x_start_date_active
553: ,x_end_date_active
554: from pa_bill_rates_all bill_rates
555: where trunc(p_txn_date) between trunc(bill_rates.start_date_active)
556: and trunc(nvl(bill_rates.end_date_active, p_txn_date))
557: and bill_rates.job_id = l_dest_job_id
558: and bill_rates.bill_rate_sch_id = x_rate_sch_id

Line 738: ,pa_bill_rates_all bill_rates

734: and trunc(p_txn_date) between trunc(assign.start_date_active)
735: and trunc(nvl(assign.end_date_active,p_txn_date))
736: and (exists( select null
737: from pa_std_bill_rate_schedules_all rate_sch
738: ,pa_bill_rates_all bill_rates
739: where rate_sch.bill_rate_sch_id =
740: decode(p_calling_module ,'REQUIREMENT'
741: ,assign.forecast_cost_rate_sch_id,assign.cost_rate_sch_id)
742: and bill_rates.bill_rate_sch_id = rate_sch.bill_rate_sch_id

Line 751: ,pa_bill_rates_all bill_rates

747: )
748: or
749: exists( select null
750: from pa_std_bill_rate_schedules_all rate_sch
751: ,pa_bill_rates_all bill_rates
752: where rate_sch.bill_rate_sch_id =
753: decode(p_calling_module ,'REQUIREMENT'
754: ,assign.forecast_cost_rate_sch_id,assign.cost_rate_sch_id)
755: and bill_rates.bill_rate_sch_id = rate_sch.bill_rate_sch_id

Line 1050: RETURN pa_bill_rates_all.rate%type IS

1046: ,P_Effective_Date IN date
1047: ,P_Rate_Type IN varchar2
1048: ,P_Called_From IN varchar2 DEFAULT 'O' /* Added for 3405326 */
1049: )
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;

Line 1055: l_cost_rate pa_bill_rates_all.rate%type;

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;
1059: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;

Line 1056: l_acct_cost_rate pa_bill_rates_all.rate%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;
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;

Line 1070: l_return_rate pa_bill_rates_all.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;
1070: l_return_rate pa_bill_rates_all.rate%type;
1071: l_acct_currency_code varchar2(15);
1072: l_conversion_date date;
1073: l_numerator number;
1074: l_denominator number;

Line 1226: l_cost_rate pa_bill_rates_all.rate%type;

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;
1230: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;