APPS.PER_SSHR_CHANGE_PAY dependencies on DUAL

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

2691: end if;
2692: --
2693: if l_last_currency <> update_recs.input_currency_code then
2694: 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
2695: from dual;
2696: else
2697: l_xchg_rate := 1;
2698: end if;
2699: --

Line 2718: from dual;

2714: else
2715: --
2716: if l_last_currency <> update_recs.input_currency_code then
2717: 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
2718: from dual;
2719: else
2720: l_xchg_rate := 1;
2721: end if;
2722: --

Line 2772: from dual;

2768: end if;
2769: --
2770: if l_last_currency <> update_recs.input_currency_code then
2771: 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
2772: from dual;
2773: else
2774: l_xchg_rate := 1;
2775: end if;
2776: --

Line 2794: from dual;

2790: end if;
2791: --
2792: if l_last_currency <> update_recs.input_currency_code then
2793: 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
2794: from dual;
2795: else
2796: l_xchg_rate := 1;
2797: end if;
2798: --