APPS.PER_SSHR_CHANGE_PAY dependencies on PER_PAY_TRANSACTIONS_S

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