APPS.PA_COST_RATE_PUB dependencies on PA_COMPENSATION_DETAILS_ALL

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