APPS.PA_COST_RATE_PUB dependencies on PA_COMPENSATION_DETAILS_ALL

Line 252: from pa_compensation_details_all detail /*2879644:Added ALL*/

248: ,x_acct_rate_date_code
249: ,x_acct_exch_rate
250: ,x_start_date_active
251: ,x_end_date_active
252: from pa_compensation_details_all detail /*2879644:Added ALL*/
253: where trunc(p_txn_date) between trunc(detail.start_date_active)
254: and trunc(nvl(detail.end_date_active,p_txn_date))
255: and NVL(detail.org_id,-99) = NVL(g_ou_id,-99) /*2879644 :Added org_id join*/
256: and detail.person_id = p_person_id;

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

530: ,x_ot_task_id IN OUT NOCOPY pa_tasks.task_id%TYPE
531: ,x_cost_rate_curr_code IN OUT NOCOPY pa_expenditure_items_all.denom_currency_code%TYPE
532: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
533: ,x_acct_rate_date_code IN OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE
534: ,x_acct_exch_rate IN OUT NOCOPY pa_compensation_details_all.acct_exchange_rate%TYPE
535: ,x_err_stage IN OUT NOCOPY number
536: ,x_err_code IN OUT NOCOPY varchar2
537: ,P_Called_From IN varchar2 DEFAULT 'O' /* Added for 3405326 */
538: )

Line 816: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;

812: RETURN pa_bill_rates_all.rate%type IS
813: l_job_id pa_expenditure_items_all.job_id%type;
814: l_organization_id pa_expenditures_all.incurred_by_organization_id%type;
815: l_org_id pa_expenditures_all.org_id%type; /*2879644*/
816: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;
817: l_cost_rate pa_bill_rates_all.rate%type;
818: l_acct_cost_rate pa_bill_rates_all.rate%type;
819: l_start_date_active date;
820: l_end_date_active date;

Line 987: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;

983: RETURN VARCHAR2 IS
984: l_job_id pa_expenditure_items_all.job_id%type;
985: l_organization_id pa_expenditures_all.incurred_by_organization_id%type;
986: l_org_id pa_expenditures_all.org_id%TYPE ; /*2879644*/
987: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;
988: l_cost_rate pa_bill_rates_all.rate%type;
989: l_start_date_active date;
990: l_end_date_active date;
991: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;