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.PER_SSHR_CHANGE_PAY dependencies on HR_API_TRANSACTIONS

Line 28: hr_api_transactions hat,

24: --
25: Cursor csr_gsp_ladder_id Is
26: select hatv.number_value
27: from hr_api_transaction_steps hats,
28: hr_api_transactions hat,
29: hr_api_transaction_values hatv
30: where hats.api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API'
31: and hatv.transaction_step_id = hats.transaction_step_id
32: and hatv.name = 'P_GRADE_LADDER_PGM_ID'

Line 305: Update hr_api_transactions

301: p_transaction_id => l_transaction_id,
302: p_transaction_step_id => l_transaction_step_id,
303: p_update_mode => l_update_mode);
304: --
305: Update hr_api_transactions
306: set transaction_effective_date = trunc(P_EFFECTIVE_DATE)
307: where transaction_id = l_transaction_id;
308: --
309: wf_engine.setitemattrtext (itemtype => p_item_type

Line 1268: hr_api_transactions hat,

1264: Cursor csr_txn_basis_change_date Is
1265: select hatv1.date_value date_value
1266: from hr_api_transaction_values hatv,
1267: hr_api_transaction_steps hats,
1268: hr_api_transactions hat,
1269: hr_api_transaction_values hatv1
1270: where hatv.NAME = 'P_PAY_BASIS_ID'
1271: and hatv1.NAME = 'P_EFFECTIVE_DATE'
1272: and hatv1.TRANSACTION_STEP_ID = hats.TRANSACTION_STEP_ID

Line 3146: From hr_api_transactions

3142:
3143: --
3144: Cursor csr_eff_date is
3145: Select TRANSACTION_EFFECTIVE_DATE, EFFECTIVE_DATE_OPTION
3146: From hr_api_transactions
3147: Where transaction_id = (Select transaction_id from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id);
3148: --
3149: --
3150: l_pay_proposal_id per_pay_proposals.pay_proposal_id%type;

Line 3168: l_transaction_effective_date hr_api_transactions.TRANSACTION_EFFECTIVE_DATE%type;

3164: l_item_type hr_api_transaction_steps.item_type%type;
3165: l_item_key hr_api_transaction_steps.item_key%type;
3166: --
3167: --
3168: l_transaction_effective_date hr_api_transactions.TRANSACTION_EFFECTIVE_DATE%type;
3169: l_effective_date_option hr_api_transactions.EFFECTIVE_DATE_OPTION%type;
3170: --
3171: Begin
3172: --

Line 3169: l_effective_date_option hr_api_transactions.EFFECTIVE_DATE_OPTION%type;

3165: l_item_key hr_api_transaction_steps.item_key%type;
3166: --
3167: --
3168: l_transaction_effective_date hr_api_transactions.TRANSACTION_EFFECTIVE_DATE%type;
3169: l_effective_date_option hr_api_transactions.EFFECTIVE_DATE_OPTION%type;
3170: --
3171: Begin
3172: --
3173: hr_utility.set_location('Entering '||l_proc,10);

Line 3735: hr_api_transactions hat,

3731: Cursor csr_txn_basis_change_date Is
3732: select hatv1.date_value ,hatv.number_value, hatv.original_number_value
3733: from hr_api_transaction_values hatv,
3734: hr_api_transaction_steps hats,
3735: hr_api_transactions hat,
3736: hr_api_transaction_values hatv1
3737: where hatv.NAME = 'P_PAY_BASIS_ID'
3738: and hatv1.NAME = 'P_EFFECTIVE_DATE'
3739: and hatv1.TRANSACTION_STEP_ID = hats.TRANSACTION_STEP_ID

Line 3750: hr_api_transactions hat,

3746: --
3747: Cursor csr_txn_asst_change_date Is
3748: select hatv.date_value
3749: from hr_api_transaction_steps hats,
3750: hr_api_transactions hat,
3751: hr_api_transaction_values hatv
3752: where hats.api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API'
3753: and hatv.transaction_step_id = hats.transaction_step_id
3754: and hatv.name = 'P_EFFECTIVE_DATE'

Line 3814: hr_api_transactions hat

3810: select hatv.number_value,
3811: hatv.original_number_value
3812: from hr_api_transaction_values hatv,
3813: hr_api_transaction_steps hats,
3814: hr_api_transactions hat
3815: where hatv.NAME = 'P_PAY_BASIS_ID'
3816: and hatv.TRANSACTION_STEP_ID = hats.TRANSACTION_STEP_ID
3817: and hats.TRANSACTION_ID = hat.TRANSACTION_ID
3818: and hat.TRANSACTION_ID = p_transaction_id;

Line 4331: hr_api_transactions hat,

4327: Cursor csr_txn_basis_change_date Is
4328: select hatv1.date_value ,hatv.number_value
4329: from hr_api_transaction_values hatv,
4330: hr_api_transaction_steps hats,
4331: hr_api_transactions hat,
4332: hr_api_transaction_values hatv1
4333: where hatv.NAME = 'P_PAY_BASIS_ID'
4334: and hatv1.NAME = 'P_EFFECTIVE_DATE'
4335: and hatv1.TRANSACTION_STEP_ID = hats.TRANSACTION_STEP_ID

Line 4865: hr_api_transactions hat,

4861: Cursor csr_txn_basis_change_date Is
4862: select hatv1.date_value ,hatv.number_value, hatv.original_number_value
4863: from hr_api_transaction_values hatv,
4864: hr_api_transaction_steps hats,
4865: hr_api_transactions hat,
4866: hr_api_transaction_values hatv1
4867: where hatv.NAME = 'P_PAY_BASIS_ID'
4868: and hatv1.NAME = 'P_EFFECTIVE_DATE'
4869: and hatv1.TRANSACTION_STEP_ID = hats.TRANSACTION_STEP_ID

Line 4880: hr_api_transactions hat,

4876: --
4877: Cursor csr_txn_asst_change_date Is
4878: select hatv.date_value
4879: from hr_api_transaction_steps hats,
4880: hr_api_transactions hat,
4881: hr_api_transaction_values hatv
4882: where hats.api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API'
4883: and hatv.transaction_step_id = hats.transaction_step_id
4884: and hatv.name = 'P_EFFECTIVE_DATE'