APPS.PAY_RETRO_STATUS_INTERNAL dependencies on PAY_RETRO_ENTRIES

Line 15: subtype t_retro_ent_rec is pay_retro_entries%rowtype;

11: --
12: -- Global Definitions
13: --
14: subtype t_retro_asg_rec is pay_retro_assignments%rowtype;
15: subtype t_retro_ent_rec is pay_retro_entries%rowtype;
16:
17: --
18: -- ----------------------------------------------------------------------------
19: -- |-----------------------< get_unprocessed_retro_asg >----------------------|

Line 157: from pay_retro_entries

153: --
154: cursor csr_retro_ent_type
155: is
156: select sum(distinct decode(owner_type,'S',1, 'U',2, 'M',4, 1)) owntype_sum
157: from pay_retro_entries
158: where retro_assignment_id = p_retro_assignment_id
159: ;
160: --
161: l_ownertype_sum number;

Line 479: from pay_retro_entries

475: --
476: cursor csr_chk_rep_date
477: is
478: select 1
479: from pay_retro_entries
480: where
481: retro_assignment_id = p_retro_assignment_id
482: and reprocess_date < p_reprocess_date;
483:

Line 556: select 1 from pay_retro_entries

552: l_dummy number;
553: --
554: cursor csr_sys_ent_exists
555: is
556: select 1 from pay_retro_entries
557: where retro_assignment_id = p_retro_assignment_id
558: and nvl(owner_type, g_system) <> g_user;
559: --
560: begin

Line 1461: select 1 from pay_retro_entries

1457: l_system_entry_exists varchar2(1) := 'N';
1458:
1459: cursor csr_sys_ent_exists
1460: is
1461: select 1 from pay_retro_entries
1462: where retro_assignment_id = p_retro_assignment_id
1463: and nvl(owner_type, g_system) <> g_user;
1464: /* Bug 13696751, changes end */
1465: begin

Line 1658: from pay_retro_entries

1654: ,min(effective_date)
1655: into
1656: l_reprocess_date
1657: ,l_start_date
1658: from pay_retro_entries
1659: where
1660: retro_assignment_id = p_retro_assignment_id
1661: ;
1662:

Line 1803: delete from pay_retro_entries pre

1799: hr_utility.set_location(l_proc, 80);
1800: --
1801: -- Delete child retro entries.
1802: --
1803: delete from pay_retro_entries pre
1804: where retro_assignment_id = p_retro_assignment_id;
1805: hr_utility.set_location(l_proc, 90);
1806: --
1807: -- Reverse the child retro assignment superseded by this retro assignment.

Line 1905: from pay_retro_entries

1901: --
1902: cursor csr_lock_retro_ent
1903: is
1904: select *
1905: from pay_retro_entries
1906: where retro_assignment_id = p_retro_assignment_id
1907: and element_entry_id = p_element_entry_id
1908: for update nowait;
1909: begin

Line 1927: fnd_message.set_token('TABLE_NAME', 'pay_retro_entries');

1923: Exception
1924: When HR_Api.Object_Locked then
1925: --
1926: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1927: fnd_message.set_token('TABLE_NAME', 'pay_retro_entries');
1928: fnd_message.raise_error;
1929: end lock_retro_entry;
1930: --
1931: -- ----------------------------------------------------------------------------

Line 2139: update pay_retro_entries

2135: if p_reprocess_date <> l_new_rec.reprocess_date then
2136: --
2137: hr_utility.set_location(l_proc, 190);
2138: --
2139: update pay_retro_entries
2140: set reprocess_date = p_reprocess_date
2141: ,effective_date = p_reprocess_date
2142: where
2143: retro_assignment_id = p_retro_assignment_id

Line 2232: delete from pay_retro_entries

2228: );
2229:
2230: hr_utility.set_location(l_proc, 60);
2231:
2232: delete from pay_retro_entries
2233: where retro_assignment_id = p_retro_assignment_id
2234: and element_entry_id = p_element_entry_id
2235: ;
2236: