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 306: Update hr_api_transactions

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

Line 1276: hr_api_transactions hat,

1272: Cursor csr_txn_basis_change_date Is
1273: select hatv1.date_value date_value
1274: from hr_api_transaction_values hatv,
1275: hr_api_transaction_steps hats,
1276: hr_api_transactions hat,
1277: hr_api_transaction_values hatv1
1278: where hatv.NAME = 'P_PAY_BASIS_ID'
1279: and hatv1.NAME = 'P_EFFECTIVE_DATE'
1280: and hatv1.TRANSACTION_STEP_ID = hats.TRANSACTION_STEP_ID

Line 1355: hr_api_transactions hat

1351: --
1352: cursor csr_recs_on_top(c_assignment_id number, c_change_date date) is
1353: select max(change_date)
1354: from per_pay_transactions ppt,
1355: hr_api_transactions hat
1356: where ppt.ASSIGNMENT_ID = c_assignment_id
1357: and ppt.change_date > c_change_date
1358: and ppt.transaction_id=hat.transaction_id
1359: and hat.status<>'AC';

Line 3171: From hr_api_transactions

3167:
3168: --
3169: Cursor csr_eff_date is
3170: Select TRANSACTION_EFFECTIVE_DATE, EFFECTIVE_DATE_OPTION
3171: From hr_api_transactions
3172: Where transaction_id = (Select transaction_id from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id);
3173: --
3174: --
3175: l_pay_proposal_id per_pay_proposals.pay_proposal_id%type;

Line 3193: l_transaction_effective_date hr_api_transactions.TRANSACTION_EFFECTIVE_DATE%type;

3189: l_item_type hr_api_transaction_steps.item_type%type;
3190: l_item_key hr_api_transaction_steps.item_key%type;
3191: --
3192: --
3193: l_transaction_effective_date hr_api_transactions.TRANSACTION_EFFECTIVE_DATE%type;
3194: l_effective_date_option hr_api_transactions.EFFECTIVE_DATE_OPTION%type;
3195: --
3196: Begin
3197: --

Line 3194: l_effective_date_option hr_api_transactions.EFFECTIVE_DATE_OPTION%type;

3190: l_item_key hr_api_transaction_steps.item_key%type;
3191: --
3192: --
3193: l_transaction_effective_date hr_api_transactions.TRANSACTION_EFFECTIVE_DATE%type;
3194: l_effective_date_option hr_api_transactions.EFFECTIVE_DATE_OPTION%type;
3195: --
3196: Begin
3197: --
3198: hr_utility.set_location('Entering '||l_proc,10);

Line 3848: hr_api_transactions hat

3844: --vkodedal 08-Apr-2009 bug#8400759
3845: select ppt.change_date
3846: from per_pay_transactions ppt,
3847: wf_item_attribute_values wf,
3848: hr_api_transactions hat
3849: where ppt.assignment_id = p_assignment_id
3850: and ppt.PARENT_PAY_TRANSACTION_ID is null
3851: and ppt.status <> 'DELETE'
3852: and wf.item_type = ppt.item_type

Line 3864: hr_api_transactions hat,

3860: Cursor csr_txn_basis_change_date Is
3861: select hatv1.date_value ,hatv.number_value, hatv.original_number_value
3862: from hr_api_transaction_values hatv,
3863: hr_api_transaction_steps hats,
3864: hr_api_transactions hat,
3865: hr_api_transaction_values hatv1
3866: where hatv.NAME = 'P_PAY_BASIS_ID'
3867: and hatv1.NAME = 'P_EFFECTIVE_DATE'
3868: and hatv1.TRANSACTION_STEP_ID = hats.TRANSACTION_STEP_ID

Line 3880: hr_api_transactions hat,

3876: --
3877: Cursor csr_txn_asst_change_date Is
3878: select hatv.date_value
3879: from hr_api_transaction_steps hats,
3880: hr_api_transactions hat,
3881: hr_api_transaction_values hatv
3882: where hats.api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API'
3883: and hatv.transaction_step_id = hats.transaction_step_id
3884: and hatv.name = 'P_EFFECTIVE_DATE'

Line 3945: hr_api_transactions hat

3941: select hatv.number_value,
3942: hatv.original_number_value
3943: from hr_api_transaction_values hatv,
3944: hr_api_transaction_steps hats,
3945: hr_api_transactions hat
3946: where hatv.NAME = 'P_PAY_BASIS_ID'
3947: and hatv.TRANSACTION_STEP_ID = hats.TRANSACTION_STEP_ID
3948: and hats.TRANSACTION_ID = hat.TRANSACTION_ID
3949: and hat.TRANSACTION_ID = p_transaction_id

Line 4453: hr_api_transactions hat

4449: where assignment_id = p_assignment_id
4450: union
4451: select change_date
4452: from per_pay_transactions ppt,
4453: hr_api_transactions hat
4454: where ppt.assignment_id = p_assignment_id
4455: and ppt.PARENT_PAY_TRANSACTION_ID is null
4456: and ppt.status <> 'DELETE'
4457: and ppt.transaction_id=hat.transaction_id

Line 4466: hr_api_transactions hat,

4462: Cursor csr_txn_basis_change_date Is
4463: select hatv1.date_value ,hatv.number_value
4464: from hr_api_transaction_values hatv,
4465: hr_api_transaction_steps hats,
4466: hr_api_transactions hat,
4467: hr_api_transaction_values hatv1
4468: where hatv.NAME = 'P_PAY_BASIS_ID'
4469: and hatv1.NAME = 'P_EFFECTIVE_DATE'
4470: and hatv1.TRANSACTION_STEP_ID = hats.TRANSACTION_STEP_ID

Line 5001: hr_api_transactions hat,

4997: Cursor csr_txn_basis_change_date Is
4998: select hatv1.date_value ,hatv.number_value, hatv.original_number_value
4999: from hr_api_transaction_values hatv,
5000: hr_api_transaction_steps hats,
5001: hr_api_transactions hat,
5002: hr_api_transaction_values hatv1
5003: where hatv.NAME = 'P_PAY_BASIS_ID'
5004: and hatv1.NAME = 'P_EFFECTIVE_DATE'
5005: and hatv1.TRANSACTION_STEP_ID = hats.TRANSACTION_STEP_ID

Line 5017: hr_api_transactions hat,

5013: --
5014: Cursor csr_txn_asst_change_date Is
5015: select hatv.date_value
5016: from hr_api_transaction_steps hats,
5017: hr_api_transactions hat,
5018: hr_api_transaction_values hatv
5019: where hats.api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API'
5020: and hatv.transaction_step_id = hats.transaction_step_id
5021: and hatv.name = 'P_EFFECTIVE_DATE'