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_PAY_INTERFACE dependencies on PA_COMPENSATION_DETAILS

Line 3126: from pa_compensation_details detail

3122: ,detail.acct_rate_type
3123: ,detail.acct_rate_date_code
3124: ,detail.acct_exchange_rate
3125: ,detail.base_hours
3126: from pa_compensation_details detail
3127: -- ,pa_expenditure_items ei
3128: ,pa_expenditures exp
3129: where trunc(p_exp_item_date) between trunc(detail.start_date_active)
3130: and trunc(nvl(detail.end_date_active,p_exp_item_date))

Line 3300: from pa_compensation_details detail

3296: ,detail.acct_rate_type
3297: ,detail.acct_rate_date_code
3298: ,detail.acct_exchange_rate
3299: ,detail.base_hours
3300: from pa_compensation_details detail
3301: ,pa_expenditure_items ei
3302: ,pa_expenditures exp
3303: where trunc(p_exp_item_date) between trunc(detail.start_date_active)
3304: and trunc(nvl(detail.end_date_active,p_exp_item_date))

Line 3421: pa_compensation_details.cost_rate_currency_code%type;

3417: IS
3418: l_pay_amount NUMBER(22,5);
3419: l_acct_pay_amount NUMBER(22,5);
3420: l_pay_amount_curr_code
3421: pa_compensation_details.cost_rate_currency_code%type;
3422: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
3423: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
3424: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
3425: l_err_code VARCHAR2(200) DEFAULT NULL;

Line 3422: l_acct_rate_type pa_compensation_details.acct_rate_type%type;

3418: l_pay_amount NUMBER(22,5);
3419: l_acct_pay_amount NUMBER(22,5);
3420: l_pay_amount_curr_code
3421: pa_compensation_details.cost_rate_currency_code%type;
3422: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
3423: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
3424: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
3425: l_err_code VARCHAR2(200) DEFAULT NULL;
3426: l_err_stage NUMBER;

Line 3423: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;

3419: l_acct_pay_amount NUMBER(22,5);
3420: l_pay_amount_curr_code
3421: pa_compensation_details.cost_rate_currency_code%type;
3422: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
3423: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
3424: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
3425: l_err_code VARCHAR2(200) DEFAULT NULL;
3426: l_err_stage NUMBER;
3427: l_acct_currency_code VARCHAR2(15);

Line 3424: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;

3420: l_pay_amount_curr_code
3421: pa_compensation_details.cost_rate_currency_code%type;
3422: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
3423: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
3424: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
3425: l_err_code VARCHAR2(200) DEFAULT NULL;
3426: l_err_stage NUMBER;
3427: l_acct_currency_code VARCHAR2(15);
3428: l_conversion_date DATE;