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 143: from per_pay_transactions

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

Line 154: from per_pay_transactions

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

Line 1354: from per_pay_transactions ppt,

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

Line 1415: from per_pay_transactions ppt,

1411: ppt.PRIOR_PAY_PROPOSAL_ID,
1412: ppt.PRIOR_PAY_TRANSACTION_ID,
1413: ppt.APPROVED,
1414: ppt.object_version_number
1415: from per_pay_transactions ppt,
1416: per_pay_bases ppb,
1417: pay_input_values_f piv,
1418: pay_element_types_f pet
1419: where ppt.assignment_id = c_assgn_id

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

1493: AND ppb.pay_basis_id = paaf.pay_basis_id AND ppb.input_value_id = piv.input_value_id
1494: AND c_effective_dt BETWEEN piv.effective_start_date AND piv.effective_end_date
1495: AND piv.element_type_id = pet.element_type_id
1496: AND c_effective_dt BETWEEN pet.effective_start_date AND pet.effective_end_date
1497: AND pay.pay_proposal_id not in (select nvl(pay_proposal_id, -1) from per_pay_transactions
1498: where assignment_id = pay.assignment_id
1499: and TRANSACTION_ID = c_transaction_id)
1500: ORDER by change_date asc;
1501:

Line 1680: delete from per_pay_transactions

1676: if delete_recs.from_tab = 'TRANSACTION' then
1677: --
1678: if delete_recs.pay_proposal_id is null then
1679: --
1680: delete from per_pay_transactions
1681: where parent_pay_transaction_id = delete_recs.pay_transaction_id;
1682: --
1683: delete from per_pay_transactions
1684: where pay_transaction_id = delete_recs.pay_transaction_id;

Line 1683: delete from per_pay_transactions

1679: --
1680: delete from per_pay_transactions
1681: where parent_pay_transaction_id = delete_recs.pay_transaction_id;
1682: --
1683: delete from per_pay_transactions
1684: where pay_transaction_id = delete_recs.pay_transaction_id;
1685: --
1686: else
1687: update per_pay_transactions

Line 1687: update per_pay_transactions

1683: delete from per_pay_transactions
1684: where pay_transaction_id = delete_recs.pay_transaction_id;
1685: --
1686: else
1687: update per_pay_transactions
1688: set STATUS = 'DELETE',
1689: DML_OPERATION = 'DELETE'
1690: where parent_pay_transaction_id = delete_recs.pay_transaction_id;
1691: --

Line 1692: update per_pay_transactions

1688: set STATUS = 'DELETE',
1689: DML_OPERATION = 'DELETE'
1690: where parent_pay_transaction_id = delete_recs.pay_transaction_id;
1691: --
1692: update per_pay_transactions
1693: set STATUS = 'DELETE',
1694: DML_OPERATION = 'DELETE'
1695: where pay_transaction_id = delete_recs.pay_transaction_id;
1696: --

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

1702: if g_debug then
1703: hr_utility.set_location('Inserting when p_changedt_last NULL:'|| l_proc, 70);
1704: end if;
1705: --
1706: select PER_PAY_TRANSACTIONS_S.NEXTVAL into l_seq_val from dual;
1707: --
1708: insert into per_pay_transactions
1709: (PAY_TRANSACTION_ID ,--PAY_TRANSACTION_ID,
1710: TRANSACTION_ID, -- TRANSACTION_ID,

Line 1708: insert into per_pay_transactions

1704: end if;
1705: --
1706: select PER_PAY_TRANSACTIONS_S.NEXTVAL into l_seq_val from dual;
1707: --
1708: insert into per_pay_transactions
1709: (PAY_TRANSACTION_ID ,--PAY_TRANSACTION_ID,
1710: TRANSACTION_ID, -- TRANSACTION_ID,
1711: TRANSACTION_STEP_ID,-- TRANSACTION_STEP_ID,
1712: ITEM_TYPE,-- ITEM_TYPE,

Line 1808: insert into per_pay_transactions

1804: if l_last_row.multiple_components = 'Y' then
1805: --
1806: for rec_update_comps in csr_update_comps(l_last_row.pay_proposal_id) loop
1807: --
1808: insert into per_pay_transactions
1809: (PAY_TRANSACTION_ID ,--PAY_TRANSACTION_ID,
1810: TRANSACTION_ID, -- TRANSACTION_ID,
1811: TRANSACTION_STEP_ID,-- TRANSACTION_STEP_ID,
1812: ITEM_TYPE,-- ITEM_TYPE,

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

1854: PRIOR_PAY_TRANSACTION_ID,-- PRIOR_PAY_TRANSACTION_ID,
1855: APPROVED,
1856: object_version_number
1857: )
1858: values(PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,
1859: p_transaction_id, -- TRANSACTION_ID,
1860: p_transaction_step_id,-- TRANSACTION_STEP_ID,
1861: p_item_type,-- ITEM_TYPE,
1862: p_item_key,-- ITEM_KEY,

Line 1935: update per_pay_transactions

1931: end if;
1932: --
1933: --
1934: --update the last record with current recs date_to
1935: update per_pay_transactions
1936: set date_to = l_curr_date_to
1937: where pay_transaction_id = l_last_trans_id;
1938: --
1939: else

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

1943: hr_utility.set_location('Inserting last rec from PROPO:'|| l_proc, 120);
1944: end if;
1945: --
1946: --
1947: select PER_PAY_TRANSACTIONS_S.NEXTVAL into l_seq_val from dual;--replace by Seq number
1948: --
1949: insert into per_pay_transactions
1950: (PAY_TRANSACTION_ID ,--PAY_TRANSACTION_ID,
1951: TRANSACTION_ID, -- TRANSACTION_ID,

Line 1949: insert into per_pay_transactions

1945: --
1946: --
1947: select PER_PAY_TRANSACTIONS_S.NEXTVAL into l_seq_val from dual;--replace by Seq number
1948: --
1949: insert into per_pay_transactions
1950: (PAY_TRANSACTION_ID ,--PAY_TRANSACTION_ID,
1951: TRANSACTION_ID, -- TRANSACTION_ID,
1952: TRANSACTION_STEP_ID,-- TRANSACTION_STEP_ID,
1953: ITEM_TYPE,-- ITEM_TYPE,

Line 2050: insert into per_pay_transactions

2046: );
2047: if l_last_row.MULTIPLE_COMPONENTS = 'Y' then
2048: --
2049: for rec_update_comps in csr_update_comps(l_last_row.pay_proposal_id) loop
2050: insert into per_pay_transactions
2051: (PAY_TRANSACTION_ID ,--PAY_TRANSACTION_ID,
2052: TRANSACTION_ID, -- TRANSACTION_ID,
2053: TRANSACTION_STEP_ID,-- TRANSACTION_STEP_ID,
2054: ITEM_TYPE,-- ITEM_TYPE,

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

2096: PRIOR_PAY_TRANSACTION_ID,-- PRIOR_PAY_TRANSACTION_ID,
2097: APPROVED,
2098: object_version_number
2099: )
2100: values(PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,
2101: p_transaction_id, -- TRANSACTION_ID,
2102: p_transaction_step_id,-- TRANSACTION_STEP_ID,
2103: p_item_type,-- ITEM_TYPE,
2104: p_item_key,-- ITEM_KEY,

Line 2168: delete from per_pay_transactions

2164: if delete_recs.pay_proposal_id is null then
2165: --
2166: l_last_change_date_curr := delete_recs.last_change_date;
2167: --
2168: delete from per_pay_transactions
2169: where parent_pay_transaction_id = delete_recs.pay_transaction_id;
2170: --
2171: delete from per_pay_transactions
2172: where pay_transaction_id = delete_recs.pay_transaction_id;

Line 2171: delete from per_pay_transactions

2167: --
2168: delete from per_pay_transactions
2169: where parent_pay_transaction_id = delete_recs.pay_transaction_id;
2170: --
2171: delete from per_pay_transactions
2172: where pay_transaction_id = delete_recs.pay_transaction_id;
2173: --
2174: else
2175: --

Line 2178: update per_pay_transactions

2174: else
2175: --
2176: l_last_change_date_curr := delete_recs.last_change_date;
2177: --
2178: update per_pay_transactions
2179: set STATUS = 'DELETE',
2180: DML_OPERATION = 'DELETE'
2181: where parent_pay_transaction_id = delete_recs.pay_transaction_id;
2182: --

Line 2183: update per_pay_transactions

2179: set STATUS = 'DELETE',
2180: DML_OPERATION = 'DELETE'
2181: where parent_pay_transaction_id = delete_recs.pay_transaction_id;
2182: --
2183: update per_pay_transactions
2184: set STATUS = 'DELETE',
2185: DML_OPERATION = 'DELETE'
2186: where pay_transaction_id = delete_recs.pay_transaction_id;
2187:

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

2188: end if;
2189: --
2190: else
2191: --
2192: select PER_PAY_TRANSACTIONS_S.NEXTVAL into l_seq_val from dual; --replace by Seq number
2193: --
2194: --
2195: if g_debug then
2196: hr_utility.set_location('Inserting curr rec PROPOSAL:'|| l_proc, 110);

Line 2201: insert into per_pay_transactions

2197: end if;
2198: --
2199: l_last_change_date_curr := delete_recs.last_change_date;
2200: --
2201: insert into per_pay_transactions
2202: (PAY_TRANSACTION_ID ,--PAY_TRANSACTION_ID,
2203: TRANSACTION_ID, -- TRANSACTION_ID,
2204: TRANSACTION_STEP_ID,-- TRANSACTION_STEP_ID,
2205: ITEM_TYPE,-- ITEM_TYPE,

Line 2303: insert into per_pay_transactions

2299: --
2300: if delete_recs.MULTIPLE_COMPONENTS = 'Y' then
2301: --
2302: for rec_update_comps in csr_update_comps(delete_recs.pay_proposal_id) loop
2303: insert into per_pay_transactions
2304: (PAY_TRANSACTION_ID ,--PAY_TRANSACTION_ID,
2305: TRANSACTION_ID, -- TRANSACTION_ID,
2306: TRANSACTION_STEP_ID,-- TRANSACTION_STEP_ID,
2307: ITEM_TYPE,-- ITEM_TYPE,

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

2349: PRIOR_PAY_TRANSACTION_ID,-- PRIOR_PAY_TRANSACTION_ID,
2350: APPROVED,
2351: object_version_number
2352: )
2353: values(PER_PAY_TRANSACTIONS_S.NEXTVAL ,--PAY_TRANSACTION_ID,
2354: p_transaction_id, -- TRANSACTION_ID,
2355: p_transaction_step_id,-- TRANSACTION_STEP_ID,
2356: p_item_type,-- ITEM_TYPE,
2357: p_item_key,-- ITEM_KEY,

Line 2438: delete from per_pay_transactions

2434: and l_changedt_last is null
2435: and l_last_row.pay_proposal_id is not null
2436: and l_last_row.status = 'DATE_ADJUSTED' then
2437: --
2438: delete from per_pay_transactions
2439: where PAY_TRANSACTION_ID = l_last_row.PAY_TRANSACTION_ID;
2440: --
2441: end if;
2442: --

Line 2466: from per_pay_transactions ppt

2462: ppt.pay_transaction_id,
2463: ppt.PROPOSED_SALARY_N,
2464: ppt.CHANGE_AMOUNT_N,
2465: ppt.CHANGE_PERCENTAGE
2466: from per_pay_transactions ppt
2467: where ppt.PARENT_PAY_TRANSACTION_ID = p_pay_transaction_id
2468: AND ppt.assignment_id = p_ASSIGNMENT_ID
2469: --AND ppt.change_date = p_change_date
2470: AND ppt.status <> 'DELETE';

Line 2508: update per_pay_transactions

2504: if g_debug then
2505: hr_utility.set_location('Entering: prior Update:p_prior_transaction_id'||p_prior_transaction_id, 10);
2506: end if;
2507: --
2508: update per_pay_transactions
2509: set change_amount_n = (update_comp_recs.change_percentage * p_prior_proposed_salary*p_xchg_rate/100),
2510: PRIOR_PROPOSED_SALARY_N = p_prior_proposed_salary,
2511: PRIOR_PAY_PROPOSAL_ID = p_prior_proposal_id,
2512: PRIOR_PAY_TRANSACTION_ID = p_prior_transaction_id,

Line 2524: update per_pay_transactions

2520: if g_debug then
2521: hr_utility.set_location('Entering: Else of prior Update'||l_proc, 10);
2522: end if;
2523: --
2524: update per_pay_transactions
2525: set change_amount_n = (update_comp_recs.change_percentage * p_prior_proposed_salary*p_xchg_rate/100)
2526: where PAY_TRANSACTION_ID = update_comp_recs.PAY_TRANSACTION_ID
2527: --and change_date = p_change_date
2528: and assignment_id = p_ASSIGNMENT_ID;

Line 2566: from per_pay_transactions ppt,

2562: ppt.PRIOR_PAY_PROPOSAL_ID,
2563: ppt.PRIOR_PAY_TRANSACTION_ID,
2564: pet.input_currency_code,
2565: ppt.object_version_number
2566: from per_pay_transactions ppt,
2567: per_pay_bases ppb,
2568: pay_input_values_f piv,
2569: pay_element_types_f pet
2570: where ppt.assignment_id = c_assgn_id

Line 2662: update per_pay_transactions

2658: hr_utility.set_location('l_prior_trans_id'||l_prior_trans_id||l_proc, 30);
2659: end if;
2660: --need to change prior record as well
2661: --when deleting only rec from PPP
2662: update per_pay_transactions
2663: set CHANGE_PERCENTAGE = null,
2664: CHANGE_AMOUNT_N = 0
2665: where parent_pay_transaction_id = l_prior_trans_id;
2666: --

Line 2667: update per_pay_transactions

2663: set CHANGE_PERCENTAGE = null,
2664: CHANGE_AMOUNT_N = 0
2665: where parent_pay_transaction_id = l_prior_trans_id;
2666: --
2667: update per_pay_transactions
2668: set CHANGE_AMOUNT_N = l_prior_proposed_sal,
2669: CHANGE_PERCENTAGE = null,
2670: last_change_date = null,
2671: PRIOR_PAY_PROPOSAL_ID = null,

Line 2702: update per_pay_transactions

2698: end if;
2699: --
2700: --
2701: --update only the % , change_amount remains same
2702: update per_pay_transactions
2703: set PRIOR_PROPOSED_SALARY_N = l_prior_proposed_sal,
2704: PRIOR_PAY_PROPOSAL_ID = l_prior_proposal_id,
2705: PRIOR_PAY_TRANSACTION_ID = l_prior_trans_id,
2706: PRIOR_PAY_BASIS_ID = l_prior_pay_basis_id,

Line 2742: update per_pay_transactions

2738: hr_utility.set_location('l_change_amt'||l_change_amount, 25);
2739: end if;
2740: ----
2741: --Update only change amount , % remains same
2742: update per_pay_transactions
2743: set PRIOR_PROPOSED_SALARY_N = l_prior_proposed_sal,
2744: PRIOR_PAY_PROPOSAL_ID = l_prior_proposal_id,
2745: PRIOR_PAY_TRANSACTION_ID = l_prior_trans_id,
2746: PRIOR_PAY_BASIS_ID = l_prior_pay_basis_id,

Line 2779: update per_pay_transactions

2775: end if;
2776: --
2777: --
2778: --update only the % , change_amount: ProposedSal remains same
2779: update per_pay_transactions
2780: 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),
2781: CHANGE_AMOUNT_N = (update_recs.proposed_salary_n - (l_prior_proposed_sal*l_xchg_rate))
2782: where PAY_TRANSACTION_ID = update_recs.PAY_TRANSACTION_ID;
2783: --

Line 2813: update per_pay_transactions

2809: l_xchg_rate);
2810:
2811: --
2812: --Update only change amount, proposedSal: % remains same
2813: update per_pay_transactions
2814: set PROPOSED_SALARY_N = (PRIOR_PROPOSED_SALARY_N*l_xchg_rate + l_change_amount),
2815: CHANGE_AMOUNT_N = l_change_amount,
2816: CHANGE_PERCENTAGE = round((l_change_amount/(prior_proposed_salary_n*l_xchg_rate)*100), 6)
2817: where PAY_TRANSACTION_ID = update_recs.PAY_TRANSACTION_ID;

Line 2844: from per_pay_transactions trans,

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

Line 2864: from per_pay_transactions trans,

2860: --
2861: --
2862: cursor csr_chk_diff_in_asgn(c_item_type in varchar2, c_item_key in varchar2, c_assgn_id in number) is
2863: select trans.pay_basis_id
2864: from per_pay_transactions trans,
2865: per_all_assignments_f asg
2866: where trans.assignment_id = c_assgn_id
2867: and trans.item_type = c_item_type
2868: and trans.item_key = c_item_key

Line 2897: delete from per_pay_transactions

2893: fetch csr_rows_to_be_deleted into l_pay_basis_id, l_pay_trans_id;
2894: --
2895: if (csr_rows_to_be_deleted%found AND l_pay_trans_id is not null) then
2896: --
2897: delete from per_pay_transactions
2898: where item_key = p_item_key
2899: and item_type = p_item_type;
2900: --
2901: p_status := 'Y';

Line 2910: delete from per_pay_transactions

2906: fetch csr_chk_diff_in_asgn into l_pay_basis_id;
2907: --
2908: if(csr_chk_diff_in_asgn%found AND l_pay_basis_id is not null) then
2909: --
2910: delete from per_pay_transactions
2911: where item_key = p_item_key
2912: and item_type = p_item_type;
2913: --
2914: p_status := 'Y';

Line 3155: Select * from per_pay_transactions

3151: Procedure process_create_pay_action(
3152: p_transaction_step_id in number) IS
3153: --
3154: Cursor csr_insert_pay is
3155: Select * from per_pay_transactions
3156: where transaction_step_id = p_transaction_step_id
3157: and dml_operation = 'INSERT'
3158: and PARENT_PAY_TRANSACTION_ID is null
3159: order by CHANGE_DATE;

Line 3162: Select * from per_pay_transactions

3158: and PARENT_PAY_TRANSACTION_ID is null
3159: order by CHANGE_DATE;
3160: --
3161: Cursor csr_insert_comp is
3162: Select * from per_pay_transactions
3163: where transaction_step_id = p_transaction_step_id
3164: and dml_operation = 'INSERT'
3165: and PARENT_PAY_TRANSACTION_ID is not null
3166: order by PARENT_PAY_TRANSACTION_ID;

Line 3280: Update per_pay_transactions

3276:
3277: --
3278: -- Write the pay_proposal_id on the component records, if any.
3279: --
3280: Update per_pay_transactions
3281: set PAY_PROPOSAL_ID = l_pay_proposal_id
3282: Where transaction_step_id = p_transaction_step_id
3283: and PARENT_PAY_TRANSACTION_ID = l_pay_rec.pay_transaction_id;
3284: --

Line 3342: Select * from per_pay_transactions

3338: p_transaction_step_id in number) IS
3339: --
3340: --
3341: Cursor csr_update_pay is
3342: Select * from per_pay_transactions
3343: where transaction_step_id = p_transaction_step_id
3344: and dml_operation = 'UPDATE'
3345: and PARENT_PAY_TRANSACTION_ID is null
3346: order by CHANGE_DATE desc;

Line 3349: Select * from per_pay_transactions

3345: and PARENT_PAY_TRANSACTION_ID is null
3346: order by CHANGE_DATE desc;
3347: --
3348: Cursor csr_update_comp is
3349: Select * from per_pay_transactions
3350: where transaction_step_id = p_transaction_step_id
3351: and dml_operation = 'UPDATE'
3352: and PARENT_PAY_TRANSACTION_ID is not null
3353: order by PARENT_PAY_TRANSACTION_ID;

Line 3482: Select * from per_pay_transactions

3478: p_transaction_step_id in number) IS
3479: --
3480: --
3481: Cursor csr_delete_pay is
3482: Select * from per_pay_transactions
3483: where transaction_step_id = p_transaction_step_id
3484: and dml_operation = 'DELETE'
3485: and PARENT_PAY_TRANSACTION_ID is null
3486: order by CHANGE_DATE;

Line 3489: Select * from per_pay_transactions

3485: and PARENT_PAY_TRANSACTION_ID is null
3486: order by CHANGE_DATE;
3487: --
3488: Cursor csr_delete_comp is
3489: Select * from per_pay_transactions
3490: where transaction_step_id = p_transaction_step_id
3491: and dml_operation = 'DELETE'
3492: and PARENT_PAY_TRANSACTION_ID is not null
3493: order by PARENT_PAY_TRANSACTION_ID;

Line 3666: Delete from per_pay_transactions

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

Line 3721: select count(*) into l_count from per_pay_transactions

3717: --
3718: --10331318, 9857930 vkodedal 01-Dec-2010 delete the step created to show proposal on review page
3719: -- if the proposal is left un touched.
3720:
3721: select count(*) into l_count from per_pay_transactions
3722: where transaction_step_id=p_transaction_step_id;
3723:
3724: if(l_count = 0 ) then
3725:

Line 3770: from per_pay_transactions

3766: --------vkodedal 09-Jul-2009 ER 4384022
3767: hr_utility.set_location('Get the assignment id '||l_proc,10);
3768:
3769: Select DISTINCT ASSIGNMENT_ID into l_asg_id
3770: from per_pay_transactions
3771: where transaction_step_id =p_transaction_step_id;
3772: --
3773: /* start of code change for bug 11065050
3774: hr_utility.set_location('Call HR_UTIL_MISC_SS.merge_attachments for asg id:'||l_asg_id,10);

Line 3788: Delete from per_pay_transactions

3784: Do not purge --ER 4691806 --vkodedal 08-Apr-2010
3785: --
3786: -- Purge data from transaction tables.
3787: --
3788: Delete from per_pay_transactions
3789: where transaction_step_id = p_transaction_step_id;
3790: --
3791: */
3792: end if;

Line 3846: from per_pay_transactions ppt,

3842: where assignment_id = p_assignment_id
3843: union
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

Line 4452: from per_pay_transactions ppt,

4448: from per_pay_proposals
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'