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

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 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 29: hr_api_transaction_values hatv

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'
33: and hats.TRANSACTION_ID = hat.TRANSACTION_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 131: from hr_api_transaction_values

127: max(col2) as pay_basis_id
128: from
129: (select decode(NAME, 'P_ASSIGNMENT_ID', NUMBER_VALUE) col1,
130: decode(NAME, 'P_PAY_BASIS_ID', NUMBER_VALUE) col2
131: from hr_api_transaction_values
132: where TRANSACTION_STEP_ID = c_transaction_step_id);
133: --
134: Cursor csr_pay_basis_exists(c_assignment_id number,c_effective_date date) IS
135: select pay_basis_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 405: update hr_api_transaction_values

401: l_tx_date(l_count) := null;
402: l_tx_type(l_count) := 'NUMBER';
403: --
404: forall i in 1..l_count
405: update hr_api_transaction_values
406: set
407: varchar2_value = l_tx_char(i),
408: number_value = l_tx_num(i),
409: date_value = l_tx_date(i)

Line 1219: insert into hr_api_transaction_values

1215:
1216: -- Insert all other assignment values as unchanged.
1217:
1218: forall i in 1..l_count
1219: insert into hr_api_transaction_values
1220: ( transaction_value_id,
1221: transaction_step_id,
1222: datatype,
1223: name,

Line 1231: ( hr_api_transaction_values_s.nextval,

1227: original_varchar2_value,
1228: original_number_value,
1229: original_date_value)
1230: Values
1231: ( hr_api_transaction_values_s.nextval,
1232: l_transaction_step_id,
1233: l_tx_type(i),
1234: l_tx_name(i),
1235: l_tx_char(i),

Line 1244: update hr_api_transaction_values

1240: l_tx_date(i));
1241:
1242: -- Update change in pay basis value
1243:
1244: update hr_api_transaction_values
1245: set
1246: number_value = p_pay_basis_id
1247: where transaction_step_id = l_transaction_step_id
1248: and name = 'P_PAY_BASIS_ID';

Line 1266: from hr_api_transaction_values hatv,

1262: is
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'

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 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 1269: hr_api_transaction_values hatv1

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
1273: and hatv.NUMBER_VALUE <> hatv.ORIGINAL_NUMBER_VALUE

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 2815: hr_api_transaction_values tr_values,

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
2819: and trans.item_key = c_item_key

Line 2816: hr_api_transaction_values tr_values2

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
2819: and trans.item_key = c_item_key
2820: and tr_steps.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 3044: insert into hr_api_transaction_values

3040: l_tx_date(2) := null;
3041: l_tx_type(2) := 'VARCHAR2';
3042: --
3043: forall i in 1..2
3044: insert into hr_api_transaction_values
3045: ( transaction_value_id,
3046: transaction_step_id,
3047: datatype,
3048: name,

Line 3056: ( hr_api_transaction_values_s.nextval,

3052: original_varchar2_value,
3053: original_number_value,
3054: original_date_value)
3055: Values
3056: ( hr_api_transaction_values_s.nextval,
3057: l_transaction_step_id,
3058: l_tx_type(i),
3059: l_tx_name(i),
3060: l_tx_char(i),

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 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 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 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 3584: raise hr_api.validate_enabled;

3580: hr_utility.set_location('After Inserts '||l_proc,10);
3581: --
3582: if nvl(p_validate,'N') = 'Y' then
3583: hr_utility.set_location('validate mode '||p_validate,10);
3584: raise hr_api.validate_enabled;
3585: Else
3586: --
3587: -- Purge data from transaction tables.
3588: --

Line 3597: when hr_api.validate_enabled then

3593: --
3594: hr_utility.set_location('Leaving '||l_proc,99);
3595: --
3596: exception
3597: when hr_api.validate_enabled then
3598: --
3599: -- As the Validate_Enabled exception has been raised
3600: -- we must rollback to the savepoint
3601: --

Line 3664: raise hr_api.validate_enabled;

3660: hr_utility.set_location('After Inserts '||l_proc,10);
3661: --
3662: if p_validate then
3663: hr_utility.set_location('validate mode '||l_proc,10);
3664: raise hr_api.validate_enabled;
3665: Else
3666: --
3667: -- Purge data from transaction tables.
3668: --

Line 3677: when hr_api.validate_enabled then

3673: --
3674: hr_utility.set_location('Leaving '||l_proc,99);
3675: --
3676: exception
3677: when hr_api.validate_enabled then
3678: --
3679: -- As the Validate_Enabled exception has been raised
3680: -- we must rollback to the savepoint
3681: --

Line 3733: from hr_api_transaction_values hatv,

3729: order by change_date desc;
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'

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 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 3736: hr_api_transaction_values hatv1

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
3740: and hatv.NUMBER_VALUE <> hatv.ORIGINAL_NUMBER_VALUE

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 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 3751: hr_api_transaction_values hatv

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'
3755: and hats.TRANSACTION_ID = hat.TRANSACTION_ID

Line 3812: from hr_api_transaction_values hatv,

3808: --
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

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 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 4329: from hr_api_transaction_values hatv,

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

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 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 4332: hr_api_transaction_values hatv1

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
4336: and hatv.NUMBER_VALUE <> hatv.ORIGINAL_NUMBER_VALUE

Line 4863: from hr_api_transaction_values hatv,

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

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 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 4866: hr_api_transaction_values hatv1

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
4870: and hatv.NUMBER_VALUE <> hatv.ORIGINAL_NUMBER_VALUE

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

Line 4881: hr_api_transaction_values hatv

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'
4885: and hats.TRANSACTION_ID = hat.TRANSACTION_ID

Line 5208: from hr_api_transaction_values

5204: ,1) as frequency
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: ) ;

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 5225: from hr_api_transaction_values

5221: Select max(position_id) position_id , max(org_id) org_id, max(bg_id) bg_id from (
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:

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