APPS.PER_SSHR_CHANGE_PAY dependencies on DUAL

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 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 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 2664: from dual;

2660: end if;
2661: --
2662: if l_last_currency <> update_recs.input_currency_code then
2663: select PER_SALADMIN_UTILITY.get_currency_rate(l_last_currency,update_recs.input_currency_code,update_recs.change_date,p_busgroup_id) into l_xchg_rate
2664: from dual;
2665: else
2666: l_xchg_rate := 1;
2667: end if;
2668: --

Line 2687: from dual;

2683: else
2684: --
2685: if l_last_currency <> update_recs.input_currency_code then
2686: select PER_SALADMIN_UTILITY.get_currency_rate(l_last_currency,update_recs.input_currency_code,update_recs.change_date,p_busgroup_id) into l_xchg_rate
2687: from dual;
2688: else
2689: l_xchg_rate := 1;
2690: end if;
2691: --

Line 2741: from dual;

2737: end if;
2738: --
2739: if l_last_currency <> update_recs.input_currency_code then
2740: select PER_SALADMIN_UTILITY.get_currency_rate(l_last_currency,update_recs.input_currency_code,update_recs.change_date,p_busgroup_id) into l_xchg_rate
2741: from dual;
2742: else
2743: l_xchg_rate := 1;
2744: end if;
2745: --

Line 2763: from dual;

2759: end if;
2760: --
2761: if l_last_currency <> update_recs.input_currency_code then
2762: select PER_SALADMIN_UTILITY.get_currency_rate(l_last_currency,update_recs.input_currency_code,update_recs.change_date,p_busgroup_id) into l_xchg_rate
2763: from dual;
2764: else
2765: l_xchg_rate := 1;
2766: end if;
2767: --