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 118: from hr_api_transaction_steps

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

Line 119: where transaction_step_id = (Select transaction_step_id from hr_api_transaction_steps

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

Line 1275: hr_api_transaction_steps hats,

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

Line 1634: from hr_api_transaction_steps

1630: end if;
1631: */
1632:
1633: select count(TRANSACTION_STEP_ID ) into l_newhire
1634: from hr_api_transaction_steps
1635: where API_NAME='HR_PROCESS_PERSON_SS.PROCESS_API'
1636: and transaction_id=p_transaction_id;
1637:
1638: if l_newhire > 0

Line 2845: hr_api_transaction_steps tr_steps,

2841: cursor csr_rows_to_be_deleted(c_item_type in varchar2, c_item_key in varchar2, c_assgn_id in number) is
2842: select trans.pay_basis_id,
2843: trans.pay_transaction_id
2844: from per_pay_transactions trans,
2845: hr_api_transaction_steps tr_steps,
2846: hr_api_transaction_values tr_values,
2847: hr_api_transaction_values tr_values2
2848: where trans.assignment_id = c_assgn_id
2849: and trans.item_type = c_item_type

Line 2873: from hr_api_transaction_steps

2869: and asg.assignment_id = trans.assignment_id
2870: and asg.pay_basis_id <> trans.pay_basis_id
2871: and trans.change_date between asg.effective_start_date and asg.effective_end_date
2872: and not exists ( select '1'
2873: from hr_api_transaction_steps
2874: where api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API'
2875: and item_type = c_item_type
2876: and item_key = c_item_key );
2877: --

Line 2983: from hr_api_transaction_steps hats

2979: p_update_mode out nocopy boolean) IS
2980: --
2981: cursor csr_txn_step is
2982: select hats.transaction_step_id
2983: from hr_api_transaction_steps hats
2984: where hats.item_type = p_item_type
2985: and hats.item_key = p_item_key
2986: -- and hats.activity_id = p_activity_id
2987: and hats.api_name = upper(p_api_name)

Line 3119: from hr_api_transaction_steps

3115: --
3116: --
3117: Cursor csr_sel_item is
3118: Select transaction_step_id,api_name
3119: from hr_api_transaction_steps
3120: where transaction_id = (Select transaction_id
3121: from hr_api_transaction_steps
3122: Where transaction_step_id = p_transaction_step_id)
3123: and api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API';

Line 3121: from hr_api_transaction_steps

3117: Cursor csr_sel_item is
3118: Select transaction_step_id,api_name
3119: from hr_api_transaction_steps
3120: where transaction_id = (Select transaction_id
3121: from hr_api_transaction_steps
3122: Where transaction_step_id = p_transaction_step_id)
3123: and api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API';
3124: --
3125: --

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

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

Line 3189: l_item_type hr_api_transaction_steps.item_type%type;

3185: l_assignment_id per_all_assignments_f.assignment_id%type;
3186: l_g_assignment_id per_all_assignments_f.assignment_id%type := null;
3187: --
3188: l_proc varchar2(61) := 'process_create_pay_action' ;
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;

Line 3190: l_item_key hr_api_transaction_steps.item_key%type;

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

Line 3544: l_item_type hr_api_transaction_steps.item_type%type;

3540: p_transaction_step_id in number,
3541: p_item_key in varchar2 default null,
3542: p_item_type in varchar2 default null) is
3543:
3544: l_item_type hr_api_transaction_steps.item_type%type;
3545: l_item_key hr_api_transaction_steps.item_key%type;
3546: l_proc varchar2(61) := 'process_new_hire' ;
3547:
3548: Cursor csr_sel_item is

Line 3545: l_item_key hr_api_transaction_steps.item_key%type;

3541: p_item_key in varchar2 default null,
3542: p_item_type in varchar2 default null) is
3543:
3544: l_item_type hr_api_transaction_steps.item_type%type;
3545: l_item_key hr_api_transaction_steps.item_key%type;
3546: l_proc varchar2(61) := 'process_new_hire' ;
3547:
3548: Cursor csr_sel_item is
3549: Select item_type,item_key

Line 3550: from hr_api_transaction_steps

3546: l_proc varchar2(61) := 'process_new_hire' ;
3547:
3548: Cursor csr_sel_item is
3549: Select item_type,item_key
3550: from hr_api_transaction_steps
3551: where transaction_step_id = p_transaction_step_id;
3552:
3553: begin
3554:

Line 3729: delete from hr_api_transaction_steps

3725:
3726: delete from hr_api_transaction_values
3727: where transaction_step_id=p_transaction_step_id;
3728:
3729: delete from hr_api_transaction_steps
3730: where transaction_step_id=p_transaction_step_id;
3731:
3732: return;
3733: end if;

Line 3863: hr_api_transaction_steps hats,

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

Line 3879: from hr_api_transaction_steps hats,

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

Line 3944: hr_api_transaction_steps hats,

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

Line 4465: hr_api_transaction_steps hats,

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

Line 5000: hr_api_transaction_steps hats,

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

Line 5016: from hr_api_transaction_steps hats,

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

Line 5350: where TRANSACTION_STEP_ID = (select TRANSACTION_STEP_ID from hr_api_transaction_steps

5346: select decode(NAME, 'P_FREQUENCY', VARCHAR2_VALUE) frequencyCol,
5347: decode(NAME, 'P_NORMAL_HOURS', NUMBER_VALUE) astHoursCol,
5348: decode(NAME, 'P_EFFECTIVE_DATE',DATE_VALUE) effDateCol
5349: from hr_api_transaction_values
5350: where TRANSACTION_STEP_ID = (select TRANSACTION_STEP_ID from hr_api_transaction_steps
5351: where API_NAME = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API'
5352: and TRANSACTION_ID = p_transaction_id)
5353: ) ;
5354:

Line 5367: where TRANSACTION_STEP_ID = (select TRANSACTION_STEP_ID from hr_api_transaction_steps

5363: select decode (NAME, 'P_POSITION_ID', NUMBER_VALUE) position_id,
5364: decode (NAME, 'P_ORGANIZATION_ID', NUMBER_VALUE) org_id,
5365: decode (NAME, 'P_BUSINESS_GROUP_ID', NUMBER_VALUE) bg_id
5366: from hr_api_transaction_values
5367: where TRANSACTION_STEP_ID = (select TRANSACTION_STEP_ID from hr_api_transaction_steps
5368: where API_NAME = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API'
5369: and TRANSACTION_ID = p_transaction_id));
5370:
5371: cursor get_pos_hrs (l_pos_id in NUMBER) is