APPS.HR_DELETE dependencies on PER_ASSIGNMENTS_F

Line 316: from per_assignments_f paf

312: cursor get_ret_asg(p_bg_id number) is
313: select pra.retro_assignment_id
314: from pay_retro_assignments pra
315: where pra.assignment_id in (select distinct paf.assignment_id
316: from per_assignments_f paf
317: where paf.business_group_id = p_bg_id);
318: --
319: cursor get_ret_comp_use(p_bg_id number) is
320: select retro_component_usage_id

Line 529: FROM per_assignments_f pa

525: FROM pay_assignment_actions paa
526: WHERE paa.assignment_action_id
527: = ppp.assignment_action_id
528: AND EXISTS (SELECT ''
529: FROM per_assignments_f pa
530: WHERE pa.assignment_id
531: = paa.assignment_id
532: AND pa.business_group_id
533: = p_business_group_id

Line 552: FROM per_assignments_f pa

548: --
549: hr_utility.set_location('hr_delete.delete_assign_low_detail',5);
550: DELETE FROM pay_process_events ppe
551: WHERE EXISTS (SELECT ''
552: FROM per_assignments_f pa
553: WHERE pa.assignment_id = ppe.assignment_id
554: AND pa.business_group_id = p_business_group_id
555: );
556: --

Line 685: (c_business_group_id per_assignments_f.business_group_id%TYPE)

681: -- Changed all following cursors to use exists and for assignments
682: -- to use the base table
683: --
684: cursor csr_get_asg
685: (c_business_group_id per_assignments_f.business_group_id%TYPE)
686: is
687: SELECT null
688: FROM sys.dual
689: WHERE exists(select null

Line 694: (c_business_group_id per_assignments_f.business_group_id%TYPE)

690: FROM per_all_assignments_f
691: WHERE business_group_id = c_business_group_id);
692: --
693: cursor csr_get_ast
694: (c_business_group_id per_assignments_f.business_group_id%TYPE)
695: is
696: SELECT null
697: FROM sys.dual
698: WHERE exists(select null

Line 926: FROM per_assignments_f pa

922: SOURCE_TYPE = 'PAF'
923: AND
924: EXISTS
925: (SELECT ''
926: FROM per_assignments_f pa
927: WHERE pa.assignment_id = pog.source_id
928: AND pa.business_group_id = p_business_group_id);
929: --
930: DELETE FROM pay_us_asg_reporting uar

Line 934: FROM per_assignments_f pa

930: DELETE FROM pay_us_asg_reporting uar
931: WHERE
932: EXISTS
933: (SELECT ''
934: FROM per_assignments_f pa
935: WHERE pa.assignment_id = uar.assignment_id
936: AND pa.business_group_id = p_business_group_id);
937: --
938: DELETE FROM pay_personal_payment_methods_f ppm

Line 950: FROM per_assignments_f pa

946: DELETE FROM per_assignment_extra_info aei
947: WHERE
948: EXISTS
949: (SELECT ''
950: FROM per_assignments_f pa
951: WHERE pa.assignment_id = aei.assignment_id
952: AND pa.business_group_id = p_business_group_id);
953: hr_utility.set_location(l_proc, 220);
954: --

Line 959: FROM per_assignments_f pa

955: DELETE FROM per_quickpaint_result_text qrt
956: WHERE
957: EXISTS
958: (SELECT ''
959: FROM per_assignments_f pa
960: WHERE pa.assignment_id = qrt.assignment_id
961: AND pa.business_group_id = p_business_group_id);
962: hr_utility.set_location(l_proc,230);
963: --

Line 966: FROM per_assignments_f pa

962: hr_utility.set_location(l_proc,230);
963: --
964: DELETE FROM pay_assignment_link_usages alu
965: WHERE EXISTS ( SELECT ''
966: FROM per_assignments_f pa
967: WHERE pa.assignment_id = alu.assignment_id
968: AND pa.business_group_id = p_business_group_id);
969: hr_utility.set_location(l_proc,235);
970: --

Line 973: FROM per_assignments_f pa

969: hr_utility.set_location(l_proc,235);
970: --
971: DELETE FROM hr_assignment_set_amendments asa
972: WHERE EXISTS ( SELECT ''
973: FROM per_assignments_f pa
974: WHERE pa.assignment_id = asa.assignment_id
975: AND pa.business_group_id = p_business_group_id);
976: hr_utility.set_location('Leaving: '||l_proc,237);
977: --