APPS.PER_SSHR_CHANGE_PAY dependencies on PER_PAY_TRANSACTIONS_S

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