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

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

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

Line 1227: insert into hr_api_transaction_values

1223:
1224: -- Insert all other assignment values as unchanged.
1225:
1226: forall i in 1..l_count
1227: insert into hr_api_transaction_values
1228: ( transaction_value_id,
1229: transaction_step_id,
1230: datatype,
1231: name,

Line 1239: ( hr_api_transaction_values_s.nextval,

1235: original_varchar2_value,
1236: original_number_value,
1237: original_date_value)
1238: Values
1239: ( hr_api_transaction_values_s.nextval,
1240: l_transaction_step_id,
1241: l_tx_type(i),
1242: l_tx_name(i),
1243: l_tx_char(i),

Line 1252: update hr_api_transaction_values

1248: l_tx_date(i));
1249:
1250: -- Update change in pay basis value
1251:
1252: update hr_api_transaction_values
1253: set
1254: number_value = p_pay_basis_id
1255: where transaction_step_id = l_transaction_step_id
1256: and name = 'P_PAY_BASIS_ID';

Line 1274: from hr_api_transaction_values hatv,

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

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

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

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

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

Line 2847: hr_api_transaction_values tr_values2

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
2850: and trans.item_key = c_item_key
2851: and tr_steps.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 3075: insert into hr_api_transaction_values

3071: l_tx_date(2) := null;
3072: l_tx_type(2) := 'VARCHAR2';
3073: --
3074: forall i in 1..2
3075: insert into hr_api_transaction_values
3076: ( transaction_value_id,
3077: transaction_step_id,
3078: datatype,
3079: name,

Line 3087: ( hr_api_transaction_values_s.nextval,

3083: original_varchar2_value,
3084: original_number_value,
3085: original_date_value)
3086: Values
3087: ( hr_api_transaction_values_s.nextval,
3088: l_transaction_step_id,
3089: l_tx_type(i),
3090: l_tx_name(i),
3091: l_tx_char(i),

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

3657: hr_utility.set_location('After Inserts '||l_proc,10);
3658: --
3659: if nvl(p_validate,'N') = 'Y' then
3660: hr_utility.set_location('validate mode '||p_validate,10);
3661: raise hr_api.validate_enabled;
3662: Else
3663: --
3664: -- Purge data from transaction tables.
3665: --

Line 3674: when hr_api.validate_enabled then

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

Line 3726: delete from hr_api_transaction_values

3722: where transaction_step_id=p_transaction_step_id;
3723:
3724: if(l_count = 0 ) then
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;

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

3759: hr_utility.set_location('After Inserts '||l_proc,10);
3760: --
3761: if p_validate then
3762: hr_utility.set_location('validate mode '||l_proc,10);
3763: raise hr_api.validate_enabled;
3764: Else
3765: --
3766: --------vkodedal 09-Jul-2009 ER 4384022
3767: hr_utility.set_location('Get the assignment id '||l_proc,10);

Line 3797: when hr_api.validate_enabled then

3793: --
3794: hr_utility.set_location('Leaving '||l_proc,99);
3795: --
3796: exception
3797: when hr_api.validate_enabled then
3798: --
3799: -- As the Validate_Enabled exception has been raised
3800: -- we must rollback to the savepoint
3801: --

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

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

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

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

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

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

Line 3943: from hr_api_transaction_values hatv,

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

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

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

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

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

Line 4999: from hr_api_transaction_values hatv,

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

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

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

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

Line 5018: hr_api_transaction_values hatv

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

Line 5349: from hr_api_transaction_values

5345: from(
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: ) ;

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

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

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