APPS.PAY_JP_ISDF_DML_PKG dependencies on PAY_ACTION_INFORMATION

Line 20: select pay_action_information_s.nextval

16: if g_debug then
17: hr_utility.set_location(l_proc,0);
18: end if;
19: --
20: select pay_action_information_s.nextval
21: into l_action_information_id
22: from dual;
23: --
24: if g_debug then

Line 1398: from pay_action_information

1394: --
1395: if l_rec.status = 'I' then
1396: --
1397: delete
1398: from pay_action_information
1399: where rowid = l_rec.row_id;
1400: --
1401: elsif l_rec.status = 'Q' then
1402: --

Line 1574: from pay_action_information

1570: --
1571: if l_rec.status = 'I' then
1572: --
1573: delete
1574: from pay_action_information
1575: where rowid = l_rec.row_id;
1576: --
1577: elsif l_rec.status = 'Q' then
1578: --

Line 1755: from pay_action_information

1751: --
1752: if l_rec.status = 'I' then
1753: --
1754: delete
1755: from pay_action_information
1756: where rowid = l_rec.row_id;
1757: --
1758: elsif l_rec.status = 'Q' then
1759: --

Line 1910: from pay_action_information

1906: --
1907: if l_rec.status = 'I' then
1908: --
1909: delete
1910: from pay_action_information
1911: where rowid = l_rec.row_id;
1912: --
1913: elsif l_rec.status = 'Q' then
1914: --

Line 2050: from pay_action_information

2046: --
2047: if l_rec.status = 'I' then
2048: --
2049: delete
2050: from pay_action_information
2051: where rowid = l_rec.row_id;
2052: --
2053: elsif l_rec.status = 'Q' then
2054: --

Line 2240: from pay_action_information

2236: --
2237: if l_rec.status = 'I' then
2238: --
2239: delete
2240: from pay_action_information
2241: where rowid = l_rec.row_id;
2242: --
2243: elsif l_rec.status = 'Q' then
2244: --

Line 2450: from pay_action_information

2446: --
2447: if l_rec.status = 'I' then
2448: --
2449: delete
2450: from pay_action_information
2451: where rowid = l_rec.row_id;
2452: --
2453: elsif l_rec.status = 'Q' then
2454: --