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 PER_PAY_TRANSACTIONS

Line 142: from per_pay_transactions

138: and c_effective_date between effective_start_date and effective_end_date;
139: --
140: Cursor csr_txn_prop is
141: select change_date
142: from per_pay_transactions
143: where p_transaction_step_id is not null
144: and transaction_step_id = p_transaction_step_id
145: and PARENT_PAY_TRANSACTION_ID is null
146: and status <> 'DELETE';

Line 153: from per_pay_transactions

149: select change_date
150: from per_pay_proposals
151: where assignment_id = p_assignment_id
152: and pay_proposal_id not in (select pay_proposal_id
153: from per_pay_transactions
154: where p_transaction_step_id is not null
155: and transaction_step_id = p_transaction_step_id
156: and PARENT_PAY_TRANSACTION_ID is null
157: and status <> 'DELETE');

Line 1345: from per_pay_transactions

1341: IS
1342: --
1343: cursor csr_recs_on_top(c_assignment_id number, c_change_date date) is
1344: select max(change_date)
1345: from per_pay_transactions
1346: where ASSIGNMENT_ID = c_assignment_id
1347: and change_date > c_change_date;
1348:
1349: cursor csr_delete_recs(c_effective_dt date, c_assgn_id number, c_changedt_curr date, c_changedt_last date

Line 1403: from per_pay_transactions ppt,

1399: ppt.PRIOR_PAY_PROPOSAL_ID,
1400: ppt.PRIOR_PAY_TRANSACTION_ID,
1401: ppt.APPROVED,
1402: ppt.object_version_number
1403: from per_pay_transactions ppt,
1404: per_pay_bases ppb,
1405: pay_input_values_f piv,
1406: pay_element_types_f pet
1407: where ppt.assignment_id = c_assgn_id

Line 1485: AND pay.pay_proposal_id not in (select nvl(pay_proposal_id, -1) from per_pay_transactions

1481: AND ppb.pay_basis_id = paaf.pay_basis_id AND ppb.input_value_id = piv.input_value_id
1482: AND c_effective_dt BETWEEN piv.effective_start_date AND piv.effective_end_date
1483: AND piv.element_type_id = pet.element_type_id
1484: AND c_effective_dt BETWEEN pet.effective_start_date AND pet.effective_end_date
1485: AND pay.pay_proposal_id not in (select nvl(pay_proposal_id, -1) from per_pay_transactions
1486: where assignment_id = pay.assignment_id
1487: and TRANSACTION_ID = c_transaction_id)
1488: ORDER by change_date asc;
1489:

Line 1649: delete from per_pay_transactions

1645: if delete_recs.from_tab = 'TRANSACTION' then
1646: --
1647: if delete_recs.pay_proposal_id is null then
1648: --
1649: delete from per_pay_transactions
1650: where parent_pay_transaction_id = delete_recs.pay_transaction_id;
1651: --
1652: delete from per_pay_transactions
1653: where pay_transaction_id = delete_recs.pay_transaction_id;

Line 1652: delete from per_pay_transactions

1648: --
1649: delete from per_pay_transactions
1650: where parent_pay_transaction_id = delete_recs.pay_transaction_id;
1651: --
1652: delete from per_pay_transactions
1653: where pay_transaction_id = delete_recs.pay_transaction_id;
1654: --
1655: else
1656: update per_pay_transactions

Line 1656: update per_pay_transactions

1652: delete from per_pay_transactions
1653: where pay_transaction_id = delete_recs.pay_transaction_id;
1654: --
1655: else
1656: update per_pay_transactions
1657: set STATUS = 'DELETE',
1658: DML_OPERATION = 'DELETE'
1659: where parent_pay_transaction_id = delete_recs.pay_transaction_id;
1660: --

Line 1661: update per_pay_transactions

1657: set STATUS = 'DELETE',
1658: DML_OPERATION = 'DELETE'
1659: where parent_pay_transaction_id = delete_recs.pay_transaction_id;
1660: --
1661: update per_pay_transactions
1662: set STATUS = 'DELETE',
1663: DML_OPERATION = 'DELETE'
1664: where pay_transaction_id = delete_recs.pay_transaction_id;
1665: --

Line 1675: select PER_PAY_TRANSACTIONS_S.NEXTVAL into l_seq_val from dual;

1671: if g_debug then
1672: hr_utility.set_location('Inserting when p_changedt_last NULL:'|| l_proc, 70);
1673: end if;
1674: --
1675: select PER_PAY_TRANSACTIONS_S.NEXTVAL into l_seq_val from dual;
1676: --
1677: insert into per_pay_transactions
1678: (PAY_TRANSACTION_ID ,--PAY_TRANSACTION_ID,
1679: TRANSACTION_ID, -- TRANSACTION_ID,

Line 1677: insert into per_pay_transactions

1673: end if;
1674: --
1675: select PER_PAY_TRANSACTIONS_S.NEXTVAL into l_seq_val from dual;
1676: --
1677: insert into per_pay_transactions
1678: (PAY_TRANSACTION_ID ,--PAY_TRANSACTION_ID,
1679: TRANSACTION_ID, -- TRANSACTION_ID,
1680: TRANSACTION_STEP_ID,-- TRANSACTION_STEP_ID,
1681: ITEM_TYPE,-- ITEM_TYPE,

Line 1777: insert into per_pay_transactions

1773: if l_last_row.multiple_components = 'Y' then
1774: --
1775: for rec_update_comps in csr_update_comps(l_last_row.pay_proposal_id) loop
1776: --
1777: insert into per_pay_transactions
1778: (PAY_TRANSACTION_ID ,--PAY_TRANSACTION_ID,
1779: TRANSACTION_ID, -- TRANSACTION_ID,
1780: TRANSACTION_STEP_ID,-- TRANSACTION_STEP_ID,
1781: ITEM_TYPE,-- ITEM_TYPE,

Line 1827: values(PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,

1823: PRIOR_PAY_TRANSACTION_ID,-- PRIOR_PAY_TRANSACTION_ID,
1824: APPROVED,
1825: object_version_number
1826: )
1827: values(PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,
1828: p_transaction_id, -- TRANSACTION_ID,
1829: p_transaction_step_id,-- TRANSACTION_STEP_ID,
1830: p_item_type,-- ITEM_TYPE,
1831: p_item_key,-- ITEM_KEY,

Line 1904: update per_pay_transactions

1900: end if;
1901: --
1902: --
1903: --update the last record with current recs date_to
1904: update per_pay_transactions
1905: set date_to = l_curr_date_to
1906: where pay_transaction_id = l_last_trans_id;
1907: --
1908: else

Line 1916: select PER_PAY_TRANSACTIONS_S.NEXTVAL into l_seq_val from dual;--replace by Seq number

1912: hr_utility.set_location('Inserting last rec from PROPO:'|| l_proc, 120);
1913: end if;
1914: --
1915: --
1916: select PER_PAY_TRANSACTIONS_S.NEXTVAL into l_seq_val from dual;--replace by Seq number
1917: --
1918: insert into per_pay_transactions
1919: (PAY_TRANSACTION_ID ,--PAY_TRANSACTION_ID,
1920: TRANSACTION_ID, -- TRANSACTION_ID,

Line 1918: insert into per_pay_transactions

1914: --
1915: --
1916: select PER_PAY_TRANSACTIONS_S.NEXTVAL into l_seq_val from dual;--replace by Seq number
1917: --
1918: insert into per_pay_transactions
1919: (PAY_TRANSACTION_ID ,--PAY_TRANSACTION_ID,
1920: TRANSACTION_ID, -- TRANSACTION_ID,
1921: TRANSACTION_STEP_ID,-- TRANSACTION_STEP_ID,
1922: ITEM_TYPE,-- ITEM_TYPE,

Line 2019: insert into per_pay_transactions

2015: );
2016: if l_last_row.MULTIPLE_COMPONENTS = 'Y' then
2017: --
2018: for rec_update_comps in csr_update_comps(l_last_row.pay_proposal_id) loop
2019: insert into per_pay_transactions
2020: (PAY_TRANSACTION_ID ,--PAY_TRANSACTION_ID,
2021: TRANSACTION_ID, -- TRANSACTION_ID,
2022: TRANSACTION_STEP_ID,-- TRANSACTION_STEP_ID,
2023: ITEM_TYPE,-- ITEM_TYPE,

Line 2069: values(PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,

2065: PRIOR_PAY_TRANSACTION_ID,-- PRIOR_PAY_TRANSACTION_ID,
2066: APPROVED,
2067: object_version_number
2068: )
2069: values(PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,
2070: p_transaction_id, -- TRANSACTION_ID,
2071: p_transaction_step_id,-- TRANSACTION_STEP_ID,
2072: p_item_type,-- ITEM_TYPE,
2073: p_item_key,-- ITEM_KEY,

Line 2137: delete from per_pay_transactions

2133: if delete_recs.pay_proposal_id is null then
2134: --
2135: l_last_change_date_curr := delete_recs.last_change_date;
2136: --
2137: delete from per_pay_transactions
2138: where parent_pay_transaction_id = delete_recs.pay_transaction_id;
2139: --
2140: delete from per_pay_transactions
2141: where pay_transaction_id = delete_recs.pay_transaction_id;

Line 2140: delete from per_pay_transactions

2136: --
2137: delete from per_pay_transactions
2138: where parent_pay_transaction_id = delete_recs.pay_transaction_id;
2139: --
2140: delete from per_pay_transactions
2141: where pay_transaction_id = delete_recs.pay_transaction_id;
2142: --
2143: else
2144: --

Line 2147: update per_pay_transactions

2143: else
2144: --
2145: l_last_change_date_curr := delete_recs.last_change_date;
2146: --
2147: update per_pay_transactions
2148: set STATUS = 'DELETE',
2149: DML_OPERATION = 'DELETE'
2150: where parent_pay_transaction_id = delete_recs.pay_transaction_id;
2151: --

Line 2152: update per_pay_transactions

2148: set STATUS = 'DELETE',
2149: DML_OPERATION = 'DELETE'
2150: where parent_pay_transaction_id = delete_recs.pay_transaction_id;
2151: --
2152: update per_pay_transactions
2153: set STATUS = 'DELETE',
2154: DML_OPERATION = 'DELETE'
2155: where pay_transaction_id = delete_recs.pay_transaction_id;
2156:

Line 2161: select PER_PAY_TRANSACTIONS_S.NEXTVAL into l_seq_val from dual; --replace by Seq number

2157: end if;
2158: --
2159: else
2160: --
2161: select PER_PAY_TRANSACTIONS_S.NEXTVAL into l_seq_val from dual; --replace by Seq number
2162: --
2163: --
2164: if g_debug then
2165: hr_utility.set_location('Inserting curr rec PROPOSAL:'|| l_proc, 110);

Line 2170: insert into per_pay_transactions

2166: end if;
2167: --
2168: l_last_change_date_curr := delete_recs.last_change_date;
2169: --
2170: insert into per_pay_transactions
2171: (PAY_TRANSACTION_ID ,--PAY_TRANSACTION_ID,
2172: TRANSACTION_ID, -- TRANSACTION_ID,
2173: TRANSACTION_STEP_ID,-- TRANSACTION_STEP_ID,
2174: ITEM_TYPE,-- ITEM_TYPE,

Line 2272: insert into per_pay_transactions

2268: --
2269: if delete_recs.MULTIPLE_COMPONENTS = 'Y' then
2270: --
2271: for rec_update_comps in csr_update_comps(delete_recs.pay_proposal_id) loop
2272: insert into per_pay_transactions
2273: (PAY_TRANSACTION_ID ,--PAY_TRANSACTION_ID,
2274: TRANSACTION_ID, -- TRANSACTION_ID,
2275: TRANSACTION_STEP_ID,-- TRANSACTION_STEP_ID,
2276: ITEM_TYPE,-- ITEM_TYPE,

Line 2322: values(PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,

2318: PRIOR_PAY_TRANSACTION_ID,-- PRIOR_PAY_TRANSACTION_ID,
2319: APPROVED,
2320: object_version_number
2321: )
2322: values(PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,
2323: p_transaction_id, -- TRANSACTION_ID,
2324: p_transaction_step_id,-- TRANSACTION_STEP_ID,
2325: p_item_type,-- ITEM_TYPE,
2326: p_item_key,-- ITEM_KEY,

Line 2407: delete from per_pay_transactions

2403: and l_changedt_last is null
2404: and l_last_row.pay_proposal_id is not null
2405: and l_last_row.status = 'DATE_ADJUSTED' then
2406: --
2407: delete from per_pay_transactions
2408: where PAY_TRANSACTION_ID = l_last_row.PAY_TRANSACTION_ID;
2409: --
2410: end if;
2411: --

Line 2435: from per_pay_transactions ppt

2431: ppt.pay_transaction_id,
2432: ppt.PROPOSED_SALARY_N,
2433: ppt.CHANGE_AMOUNT_N,
2434: ppt.CHANGE_PERCENTAGE
2435: from per_pay_transactions ppt
2436: where ppt.PARENT_PAY_TRANSACTION_ID = p_pay_transaction_id
2437: AND ppt.assignment_id = p_ASSIGNMENT_ID
2438: --AND ppt.change_date = p_change_date
2439: AND ppt.status <> 'DELETE';

Line 2477: update per_pay_transactions

2473: if g_debug then
2474: hr_utility.set_location('Entering: prior Update:p_prior_transaction_id'||p_prior_transaction_id, 10);
2475: end if;
2476: --
2477: update per_pay_transactions
2478: set change_amount_n = (update_comp_recs.change_percentage * p_prior_proposed_salary*p_xchg_rate/100),
2479: PRIOR_PROPOSED_SALARY_N = p_prior_proposed_salary,
2480: PRIOR_PAY_PROPOSAL_ID = p_prior_proposal_id,
2481: PRIOR_PAY_TRANSACTION_ID = p_prior_transaction_id,

Line 2493: update per_pay_transactions

2489: if g_debug then
2490: hr_utility.set_location('Entering: Else of prior Update'||l_proc, 10);
2491: end if;
2492: --
2493: update per_pay_transactions
2494: set change_amount_n = (update_comp_recs.change_percentage * p_prior_proposed_salary*p_xchg_rate/100)
2495: where PAY_TRANSACTION_ID = update_comp_recs.PAY_TRANSACTION_ID
2496: --and change_date = p_change_date
2497: and assignment_id = p_ASSIGNMENT_ID;

Line 2535: from per_pay_transactions ppt,

2531: ppt.PRIOR_PAY_PROPOSAL_ID,
2532: ppt.PRIOR_PAY_TRANSACTION_ID,
2533: pet.input_currency_code,
2534: ppt.object_version_number
2535: from per_pay_transactions ppt,
2536: per_pay_bases ppb,
2537: pay_input_values_f piv,
2538: pay_element_types_f pet
2539: where ppt.assignment_id = c_assgn_id

Line 2631: update per_pay_transactions

2627: hr_utility.set_location('l_prior_trans_id'||l_prior_trans_id||l_proc, 30);
2628: end if;
2629: --need to change prior record as well
2630: --when deleting only rec from PPP
2631: update per_pay_transactions
2632: set CHANGE_PERCENTAGE = null,
2633: CHANGE_AMOUNT_N = 0
2634: where parent_pay_transaction_id = l_prior_trans_id;
2635: --

Line 2636: update per_pay_transactions

2632: set CHANGE_PERCENTAGE = null,
2633: CHANGE_AMOUNT_N = 0
2634: where parent_pay_transaction_id = l_prior_trans_id;
2635: --
2636: update per_pay_transactions
2637: set CHANGE_AMOUNT_N = l_prior_proposed_sal,
2638: CHANGE_PERCENTAGE = null,
2639: last_change_date = null,
2640: PRIOR_PAY_PROPOSAL_ID = null,

Line 2671: update per_pay_transactions

2667: end if;
2668: --
2669: --
2670: --update only the % , change_amount remains same
2671: update per_pay_transactions
2672: set PRIOR_PROPOSED_SALARY_N = l_prior_proposed_sal,
2673: PRIOR_PAY_PROPOSAL_ID = l_prior_proposal_id,
2674: PRIOR_PAY_TRANSACTION_ID = l_prior_trans_id,
2675: PRIOR_PAY_BASIS_ID = l_prior_pay_basis_id,

Line 2711: update per_pay_transactions

2707: hr_utility.set_location('l_change_amt'||l_change_amount, 25);
2708: end if;
2709: ----
2710: --Update only change amount , % remains same
2711: update per_pay_transactions
2712: set PRIOR_PROPOSED_SALARY_N = l_prior_proposed_sal,
2713: PRIOR_PAY_PROPOSAL_ID = l_prior_proposal_id,
2714: PRIOR_PAY_TRANSACTION_ID = l_prior_trans_id,
2715: PRIOR_PAY_BASIS_ID = l_prior_pay_basis_id,

Line 2748: update per_pay_transactions

2744: end if;
2745: --
2746: --
2747: --update only the % , change_amount: ProposedSal remains same
2748: update per_pay_transactions
2749: set CHANGE_PERCENTAGE = round(((update_recs.proposed_salary_n - (l_prior_proposed_sal*l_xchg_rate))/(l_prior_proposed_sal*l_xchg_rate) * 100), 6),
2750: CHANGE_AMOUNT_N = (update_recs.proposed_salary_n - (l_prior_proposed_sal*l_xchg_rate))
2751: where PAY_TRANSACTION_ID = update_recs.PAY_TRANSACTION_ID;
2752: --

Line 2782: update per_pay_transactions

2778: l_xchg_rate);
2779:
2780: --
2781: --Update only change amount, proposedSal: % remains same
2782: update per_pay_transactions
2783: set PROPOSED_SALARY_N = (PRIOR_PROPOSED_SALARY_N*l_xchg_rate + l_change_amount),
2784: CHANGE_AMOUNT_N = l_change_amount,
2785: CHANGE_PERCENTAGE = round((l_change_amount/(prior_proposed_salary_n*l_xchg_rate)*100), 6)
2786: where PAY_TRANSACTION_ID = update_recs.PAY_TRANSACTION_ID;

Line 2813: from per_pay_transactions trans,

2809: IS
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

Line 2833: from per_pay_transactions trans,

2829: --
2830: --
2831: cursor csr_chk_diff_in_asgn(c_item_type in varchar2, c_item_key in varchar2, c_assgn_id in number) is
2832: select trans.pay_basis_id
2833: from per_pay_transactions trans,
2834: per_all_assignments_f asg
2835: where trans.assignment_id = c_assgn_id
2836: and trans.item_type = c_item_type
2837: and trans.item_key = c_item_key

Line 2866: delete from per_pay_transactions

2862: fetch csr_rows_to_be_deleted into l_pay_basis_id, l_pay_trans_id;
2863: --
2864: if (csr_rows_to_be_deleted%found AND l_pay_trans_id is not null) then
2865: --
2866: delete from per_pay_transactions
2867: where item_key = p_item_key
2868: and item_type = p_item_type;
2869: --
2870: p_status := 'Y';

Line 2879: delete from per_pay_transactions

2875: fetch csr_chk_diff_in_asgn into l_pay_basis_id;
2876: --
2877: if(csr_chk_diff_in_asgn%found AND l_pay_basis_id is not null) then
2878: --
2879: delete from per_pay_transactions
2880: where item_key = p_item_key
2881: and item_type = p_item_type;
2882: --
2883: p_status := 'Y';

Line 3125: Select * from per_pay_transactions

3121: p_transaction_step_id in number,
3122: p_new_hire_flag in varchar2 default null) IS
3123: --
3124: Cursor csr_insert_pay is
3125: Select * from per_pay_transactions
3126: where transaction_step_id = p_transaction_step_id
3127: and dml_operation = 'INSERT'
3128: and PARENT_PAY_TRANSACTION_ID is null
3129: order by CHANGE_DATE;

Line 3132: Select * from per_pay_transactions

3128: and PARENT_PAY_TRANSACTION_ID is null
3129: order by CHANGE_DATE;
3130: --
3131: Cursor csr_insert_comp is
3132: Select * from per_pay_transactions
3133: where transaction_step_id = p_transaction_step_id
3134: and dml_operation = 'INSERT'
3135: and PARENT_PAY_TRANSACTION_ID is not null
3136: order by PARENT_PAY_TRANSACTION_ID;

Line 3266: Update per_pay_transactions

3262:
3263: --
3264: -- Write the pay_proposal_id on the component records, if any.
3265: --
3266: Update per_pay_transactions
3267: set PAY_PROPOSAL_ID = l_pay_proposal_id
3268: Where transaction_step_id = p_transaction_step_id
3269: and PARENT_PAY_TRANSACTION_ID = l_pay_rec.pay_transaction_id;
3270: --

Line 3328: Select * from per_pay_transactions

3324: p_transaction_step_id in number) IS
3325: --
3326: --
3327: Cursor csr_update_pay is
3328: Select * from per_pay_transactions
3329: where transaction_step_id = p_transaction_step_id
3330: and dml_operation = 'UPDATE'
3331: and PARENT_PAY_TRANSACTION_ID is null
3332: order by CHANGE_DATE desc;

Line 3335: Select * from per_pay_transactions

3331: and PARENT_PAY_TRANSACTION_ID is null
3332: order by CHANGE_DATE desc;
3333: --
3334: Cursor csr_update_comp is
3335: Select * from per_pay_transactions
3336: where transaction_step_id = p_transaction_step_id
3337: and dml_operation = 'UPDATE'
3338: and PARENT_PAY_TRANSACTION_ID is not null
3339: order by PARENT_PAY_TRANSACTION_ID;

Line 3463: Select * from per_pay_transactions

3459: p_transaction_step_id in number) IS
3460: --
3461: --
3462: Cursor csr_delete_pay is
3463: Select * from per_pay_transactions
3464: where transaction_step_id = p_transaction_step_id
3465: and dml_operation = 'DELETE'
3466: and PARENT_PAY_TRANSACTION_ID is null
3467: order by CHANGE_DATE;

Line 3470: Select * from per_pay_transactions

3466: and PARENT_PAY_TRANSACTION_ID is null
3467: order by CHANGE_DATE;
3468: --
3469: Cursor csr_delete_comp is
3470: Select * from per_pay_transactions
3471: where transaction_step_id = p_transaction_step_id
3472: and dml_operation = 'DELETE'
3473: and PARENT_PAY_TRANSACTION_ID is not null
3474: order by PARENT_PAY_TRANSACTION_ID;

Line 3589: Delete from per_pay_transactions

3585: Else
3586: --
3587: -- Purge data from transaction tables.
3588: --
3589: Delete from per_pay_transactions
3590: where transaction_step_id = p_transaction_step_id;
3591: --
3592: end if;
3593: --

Line 3669: Delete from per_pay_transactions

3665: Else
3666: --
3667: -- Purge data from transaction tables.
3668: --
3669: Delete from per_pay_transactions
3670: where transaction_step_id = p_transaction_step_id;
3671: --
3672: end if;
3673: --

Line 3725: from per_pay_transactions

3721: from per_pay_proposals
3722: where assignment_id = p_assignment_id
3723: union
3724: select change_date
3725: from per_pay_transactions
3726: where assignment_id = p_assignment_id
3727: and PARENT_PAY_TRANSACTION_ID is null
3728: and status <> 'DELETE'
3729: order by change_date desc;

Line 4320: from per_pay_transactions

4316: from per_pay_proposals
4317: where assignment_id = p_assignment_id
4318: union
4319: select change_date
4320: from per_pay_transactions
4321: where assignment_id = p_assignment_id
4322: and PARENT_PAY_TRANSACTION_ID is null
4323: and status <> 'DELETE'
4324: order by change_date desc;