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_TRANSACTION_STEPS

Line 27: from hr_api_transaction_steps hats,

23: is
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

Line 117: from hr_api_transaction_steps

113: l_pay_basis per_all_assignments_f.pay_basis_id%type;
114: --
115: Cursor asg_step is
116: select transaction_id,transaction_step_id
117: from hr_api_transaction_steps
118: where transaction_step_id = (Select transaction_step_id from hr_api_transaction_steps
119: where item_key = p_item_key
120: and item_type = p_item_type
121: and api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API');

Line 118: where transaction_step_id = (Select transaction_step_id from hr_api_transaction_steps

114: --
115: Cursor asg_step is
116: select transaction_id,transaction_step_id
117: from hr_api_transaction_steps
118: where transaction_step_id = (Select transaction_step_id from hr_api_transaction_steps
119: where item_key = p_item_key
120: and item_type = p_item_type
121: and api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API');
122:

Line 1267: hr_api_transaction_steps hats,

1263:
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'

Line 2814: hr_api_transaction_steps tr_steps,

2810: cursor csr_rows_to_be_deleted(c_item_type in varchar2, c_item_key in varchar2, c_assgn_id in number) is
2811: select trans.pay_basis_id,
2812: trans.pay_transaction_id
2813: from per_pay_transactions trans,
2814: hr_api_transaction_steps tr_steps,
2815: hr_api_transaction_values tr_values,
2816: hr_api_transaction_values tr_values2
2817: where trans.assignment_id = c_assgn_id
2818: and trans.item_type = c_item_type

Line 2842: from hr_api_transaction_steps

2838: and asg.assignment_id = trans.assignment_id
2839: and asg.pay_basis_id <> trans.pay_basis_id
2840: and trans.change_date between asg.effective_start_date and asg.effective_end_date
2841: and not exists ( select '1'
2842: from hr_api_transaction_steps
2843: where api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API'
2844: and item_type = c_item_type
2845: and item_key = c_item_key );
2846: --

Line 2952: from hr_api_transaction_steps hats

2948: p_update_mode out nocopy boolean) IS
2949: --
2950: cursor csr_txn_step is
2951: select hats.transaction_step_id
2952: from hr_api_transaction_steps hats
2953: where hats.item_type = p_item_type
2954: and hats.item_key = p_item_key
2955: -- and hats.activity_id = p_activity_id
2956: and hats.api_name = upper(p_api_name)

Line 3088: from hr_api_transaction_steps

3084: --
3085: --
3086: Cursor csr_sel_item is
3087: Select transaction_step_id,api_name
3088: from hr_api_transaction_steps
3089: where transaction_id = (Select transaction_id
3090: from hr_api_transaction_steps
3091: Where transaction_step_id = p_transaction_step_id)
3092: and api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API';

Line 3090: from hr_api_transaction_steps

3086: Cursor csr_sel_item is
3087: Select transaction_step_id,api_name
3088: from hr_api_transaction_steps
3089: where transaction_id = (Select transaction_id
3090: from hr_api_transaction_steps
3091: Where transaction_step_id = p_transaction_step_id)
3092: and api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API';
3093: --
3094: --

Line 3140: from hr_api_transaction_steps

3136: order by PARENT_PAY_TRANSACTION_ID;
3137: --
3138: Cursor csr_sel_item is
3139: Select item_type,item_key
3140: from hr_api_transaction_steps
3141: where transaction_step_id = p_transaction_step_id;
3142:
3143: --
3144: Cursor csr_eff_date is

Line 3147: Where transaction_id = (Select transaction_id from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id);

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;
3151: l_pay_ovn per_pay_proposals.object_version_number%type;

Line 3164: l_item_type hr_api_transaction_steps.item_type%type;

3160: l_assignment_id per_all_assignments_f.assignment_id%type;
3161: l_g_assignment_id per_all_assignments_f.assignment_id%type := null;
3162: --
3163: l_proc varchar2(61) := 'process_create_pay_action' ;
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;

Line 3165: l_item_key hr_api_transaction_steps.item_key%type;

3161: l_g_assignment_id per_all_assignments_f.assignment_id%type := null;
3162: --
3163: l_proc varchar2(61) := 'process_create_pay_action' ;
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;

Line 3734: hr_api_transaction_steps hats,

3730: --
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'

Line 3749: from hr_api_transaction_steps hats,

3745: order by hatv1.date_value desc ;
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

Line 3813: hr_api_transaction_steps hats,

3809: Cursor csr_txn_basis_id Is
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

Line 4330: hr_api_transaction_steps hats,

4326: --
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'

Line 4864: hr_api_transaction_steps hats,

4860: --
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'

Line 4879: from hr_api_transaction_steps hats,

4875: order by hatv1.date_value desc ;
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

Line 5209: where TRANSACTION_STEP_ID = (select TRANSACTION_STEP_ID from hr_api_transaction_steps

5205: from(
5206: select decode(NAME, 'P_FREQUENCY', VARCHAR2_VALUE) frequencyCol,
5207: decode(NAME, 'P_NORMAL_HOURS', NUMBER_VALUE) astHoursCol
5208: from hr_api_transaction_values
5209: where TRANSACTION_STEP_ID = (select TRANSACTION_STEP_ID from hr_api_transaction_steps
5210: where API_NAME = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API'
5211: and TRANSACTION_ID = p_transaction_id)
5212: ) ;
5213:

Line 5226: where TRANSACTION_STEP_ID = (select TRANSACTION_STEP_ID from hr_api_transaction_steps

5222: select decode (NAME, 'P_POSITION_ID', NUMBER_VALUE) position_id,
5223: decode (NAME, 'P_ORGANIZATION_ID', NUMBER_VALUE) org_id,
5224: decode (NAME, 'P_BUSINESS_GROUP_ID', NUMBER_VALUE) bg_id
5225: from hr_api_transaction_values
5226: where TRANSACTION_STEP_ID = (select TRANSACTION_STEP_ID from hr_api_transaction_steps
5227: where API_NAME = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API'
5228: and TRANSACTION_ID = p_transaction_id));
5229:
5230: cursor get_pos_hrs (l_pos_id in NUMBER) is