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 1611: from pay_action_information

1607: --
1608: if l_rec.status = 'I' then
1609: --
1610: delete
1611: from pay_action_information
1612: where rowid = l_rec.row_id;
1613: --
1614: elsif l_rec.status = 'Q' then
1615: --

Line 1788: from pay_action_information

1784: --
1785: if l_rec.status = 'I' then
1786: --
1787: delete
1788: from pay_action_information
1789: where rowid = l_rec.row_id;
1790: --
1791: elsif l_rec.status = 'Q' then
1792: --

Line 1970: from pay_action_information

1966: --
1967: if l_rec.status = 'I' then
1968: --
1969: delete
1970: from pay_action_information
1971: where rowid = l_rec.row_id;
1972: --
1973: elsif l_rec.status = 'Q' then
1974: --

Line 2151: from pay_action_information

2147: --
2148: if l_rec.status = 'I' then
2149: --
2150: delete
2151: from pay_action_information
2152: where rowid = l_rec.row_id;
2153: --
2154: elsif l_rec.status = 'Q' then
2155: --

Line 2306: from pay_action_information

2302: --
2303: if l_rec.status = 'I' then
2304: --
2305: delete
2306: from pay_action_information
2307: where rowid = l_rec.row_id;
2308: --
2309: elsif l_rec.status = 'Q' then
2310: --

Line 2446: from pay_action_information

2442: --
2443: if l_rec.status = 'I' then
2444: --
2445: delete
2446: from pay_action_information
2447: where rowid = l_rec.row_id;
2448: --
2449: elsif l_rec.status = 'Q' then
2450: --

Line 2636: from pay_action_information

2632: --
2633: if l_rec.status = 'I' then
2634: --
2635: delete
2636: from pay_action_information
2637: where rowid = l_rec.row_id;
2638: --
2639: elsif l_rec.status = 'Q' then
2640: --

Line 2846: from pay_action_information

2842: --
2843: if l_rec.status = 'I' then
2844: --
2845: delete
2846: from pay_action_information
2847: where rowid = l_rec.row_id;
2848: --
2849: elsif l_rec.status = 'Q' then
2850: --