APPS.PAY_RETRO_PKG dependencies on PAY_RETRO_ENTRIES

Line 187: from pay_retro_entries pre

183: --
184: begin
185: select 1
186: into l_dummy
187: from pay_retro_entries pre
188: where retro_assignment_id = p_retro_asg_id
189: and retro_component_id = p_retro_comp_id
190: and element_entry_id = p_entry_id;
191: --

Line 856: PAY_RETRO_ENTRIES table.

852: /*
853: Procedure: create_retro_entry
854: Description:
855: This procedure creates an entry in the
856: PAY_RETRO_ENTRIES table.
857: */
858: procedure create_retro_entry(
859: p_retro_assignment_id IN NUMBER
860: , p_element_entry_id IN NUMBER

Line 870: INSERT INTO pay_retro_entries

866: , p_system_reprocess_date IN DATE) is
867: --
868: Begin
869: --
870: INSERT INTO pay_retro_entries
871: ( retro_assignment_id
872: , element_entry_id
873: , reprocess_date
874: , effective_date

Line 897: PAY_RETRO_ENTRIES table.

893: /*
894: Procedure: maintain_retro_entry
895: Description:
896: This procedure creates and maintains an entry in the
897: PAY_RETRO_ENTRIES table.
898: */
899: procedure maintain_retro_entry
900: (
901: p_retro_assignment_id IN NUMBER

Line 914: l_retro_component_id pay_retro_entries.retro_component_id%type;

910: l_min_reprocess_date date;
911: l_min_effective_date date;
912: l_min_sys_reprocess_date date;
913: l_owner_type varchar2(30);
914: l_retro_component_id pay_retro_entries.retro_component_id%type;
915: n_min_reprocess_date date;
916: n_min_effective_date date;
917: n_min_sys_reprocess_date date;
918: n_owner_type varchar2(30);

Line 919: n_retro_component_id pay_retro_entries.retro_component_id%type;

915: n_min_reprocess_date date;
916: n_min_effective_date date;
917: n_min_sys_reprocess_date date;
918: n_owner_type varchar2(30);
919: n_retro_component_id pay_retro_entries.retro_component_id%type;
920: --
921: begin
922: --
923: select reprocess_date,

Line 933: from pay_retro_entries

929: l_min_effective_date,
930: l_owner_type,
931: l_min_sys_reprocess_date,
932: l_retro_component_id
933: from pay_retro_entries
934: where retro_assignment_id = p_retro_assignment_id
935: and element_entry_id = p_element_entry_id;
936: --
937: -- The reprocess and effective dates are always the least if a row exists

Line 971: update pay_retro_entries

967: l_min_effective_date <> n_min_effective_date OR
968: l_min_sys_reprocess_date <> n_min_sys_reprocess_date OR
969: l_owner_type <> n_owner_type OR
970: l_retro_component_id <> n_retro_component_id) then
971: update pay_retro_entries
972: set reprocess_date = n_min_reprocess_date,
973: effective_date = n_min_effective_date,
974: retro_component_id = n_retro_component_id,
975: owner_type = n_owner_type,

Line 1028: pay_retro_entries pre

1024: pre.retro_component_id,
1025: pre.owner_type,
1026: pre.system_reprocess_date
1027: from pay_retro_assignments pra,
1028: pay_retro_entries pre
1029: where pra.assignment_id = p_assignment_id
1030: and pra.retro_assignment_action_id is null
1031: and pra.retro_assignment_id = pre.retro_assignment_id;
1032: --

Line 1060: delete from pay_retro_entries

1056: unprocrec.retro_component_id,
1057: unprocrec.owner_type,
1058: unprocrec.system_reprocess_date
1059: );
1060: delete from pay_retro_entries
1061: where element_entry_id = unprocrec.element_entry_id
1062: and retro_assignment_id = unprocrec.retro_assignment_id;
1063: --
1064: end loop;