APPS.HR_CN_API dependencies on PER_BUSINESS_GROUPS

Line 706: FROM per_business_groups pbg

702: IS
703:
704: CURSOR csr_bg IS
705: SELECT legislation_code
706: FROM per_business_groups pbg
707: WHERE pbg.business_group_id = p_business_group_id;
708: --
709: l_legislation_code per_business_groups.legislation_code%type;
710: BEGIN

Line 709: l_legislation_code per_business_groups.legislation_code%type;

705: SELECT legislation_code
706: FROM per_business_groups pbg
707: WHERE pbg.business_group_id = p_business_group_id;
708: --
709: l_legislation_code per_business_groups.legislation_code%type;
710: BEGIN
711:
712: OPEN csr_bg;
713: --

Line 760: l_legislation_code per_business_groups.legislation_code%type;

756: ,p_legislation_code IN VARCHAR2
757: ,p_effective_date IN DATE
758: )
759: IS
760: l_legislation_code per_business_groups.legislation_code%type;
761: --
762: CURSOR csr_emp_leg
763: (c_person_id per_people_f.person_id%TYPE,
764: c_effective_date DATE

Line 769: per_business_groups bgp

765: )
766: IS
767: select bgp.legislation_code
768: from per_people_f per,
769: per_business_groups bgp
770: where per.business_group_id = bgp.business_group_id
771: and per.person_id = c_person_id
772: and c_effective_date between per.effective_start_date and per.effective_END_date;
773:

Line 885: FROM per_business_groups pbg,

881: IS
882: --
883: CURSOR legsel (p_assignment_id IN NUMBER, p_effective_date IN DATE) IS
884: SELECT pbg.legislation_code
885: FROM per_business_groups pbg,
886: per_assignments_f asg
887: WHERE pbg.business_group_id = asg.business_group_id
888: AND asg.assignment_id = p_assignment_id
889: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_END_date;

Line 891: l_legislation_code per_business_groups.legislation_code%type;

887: WHERE pbg.business_group_id = asg.business_group_id
888: AND asg.assignment_id = p_assignment_id
889: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_END_date;
890: --
891: l_legislation_code per_business_groups.legislation_code%type;
892: --
893: BEGIN
894:
895: OPEN legsel(p_assignment_id, trunc(p_effective_date));

Line 956: FROM per_business_groups pbg,

952:
953: --
954: CURSOR legsel IS
955: SELECT pbg.legislation_code
956: FROM per_business_groups pbg,
957: pay_personal_payment_methods_f ppm
958: WHERE pbg.business_group_id = ppm.business_group_id
959: AND ppm.personal_payment_method_id = p_personal_payment_method_id
960: AND p_effective_date BETWEEN ppm.effective_start_date AND ppm.effective_END_date;

Line 962: l_legislation_code per_business_groups.legislation_code%type;

958: WHERE pbg.business_group_id = ppm.business_group_id
959: AND ppm.personal_payment_method_id = p_personal_payment_method_id
960: AND p_effective_date BETWEEN ppm.effective_start_date AND ppm.effective_END_date;
961: --
962: l_legislation_code per_business_groups.legislation_code%type;
963:
964: BEGIN
965:
966: OPEN legsel;