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 156: from pay_retro_entries

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

Line 521: from pay_retro_entries

517: --
518: cursor csr_chk_rep_date
519: is
520: select 1
521: from pay_retro_entries
522: where
523: retro_assignment_id = p_retro_assignment_id
524: and reprocess_date < p_reprocess_date;
525:

Line 593: select 1 from pay_retro_entries

589: l_dummy number;
590: --
591: cursor csr_sys_ent_exists
592: is
593: select 1 from pay_retro_entries
594: where retro_assignment_id = p_retro_assignment_id
595: and nvl(owner_type, g_system) <> g_user;
596: --
597: begin

Line 1655: from pay_retro_entries

1651: ,min(effective_date)
1652: into
1653: l_reprocess_date
1654: ,l_start_date
1655: from pay_retro_entries
1656: where
1657: retro_assignment_id = p_retro_assignment_id
1658: ;
1659:

Line 1757: delete from pay_retro_entries pre

1753: hr_utility.set_location(l_proc, 50);
1754: --
1755: -- Delete child retro entries.
1756: --
1757: delete from pay_retro_entries pre
1758: where retro_assignment_id = p_retro_assignment_id;
1759:
1760: --
1761: -- Reverse the child retro assignment superseded by this retro assignment.

Line 1860: from pay_retro_entries

1856: --
1857: cursor csr_lock_retro_ent
1858: is
1859: select *
1860: from pay_retro_entries
1861: where retro_assignment_id = p_retro_assignment_id
1862: and element_entry_id = p_element_entry_id
1863: for update nowait;
1864: begin

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

1878: Exception
1879: When HR_Api.Object_Locked then
1880: --
1881: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1882: fnd_message.set_token('TABLE_NAME', 'pay_retro_entries');
1883: fnd_message.raise_error;
1884: end lock_retro_entry;
1885: --
1886: -- ----------------------------------------------------------------------------

Line 2094: update pay_retro_entries

2090: if p_reprocess_date <> l_new_rec.reprocess_date then
2091: --
2092: hr_utility.set_location(l_proc, 190);
2093: --
2094: update pay_retro_entries
2095: set reprocess_date = p_reprocess_date
2096: ,effective_date = p_reprocess_date
2097: where
2098: retro_assignment_id = p_retro_assignment_id

Line 2187: delete from pay_retro_entries

2183: );
2184:
2185: hr_utility.set_location(l_proc, 60);
2186:
2187: delete from pay_retro_entries
2188: where retro_assignment_id = p_retro_assignment_id
2189: and element_entry_id = p_element_entry_id
2190: ;
2191: