APPS.HR_CN_API dependencies on PER_BUSINESS_GROUPS

Line 714: FROM per_business_groups pbg

710: IS
711:
712: CURSOR csr_bg IS
713: SELECT legislation_code
714: FROM per_business_groups pbg
715: WHERE pbg.business_group_id = p_business_group_id;
716: --
717: l_legislation_code per_business_groups.legislation_code%type;
718: BEGIN

Line 717: l_legislation_code per_business_groups.legislation_code%type;

713: SELECT legislation_code
714: FROM per_business_groups pbg
715: WHERE pbg.business_group_id = p_business_group_id;
716: --
717: l_legislation_code per_business_groups.legislation_code%type;
718: BEGIN
719:
720: OPEN csr_bg;
721: --

Line 768: l_legislation_code per_business_groups.legislation_code%type;

764: ,p_legislation_code IN VARCHAR2
765: ,p_effective_date IN DATE
766: )
767: IS
768: l_legislation_code per_business_groups.legislation_code%type;
769: --
770: CURSOR csr_emp_leg
771: (c_person_id per_people_f.person_id%TYPE,
772: c_effective_date DATE

Line 777: per_business_groups bgp

773: )
774: IS
775: select bgp.legislation_code
776: from per_people_f per,
777: per_business_groups bgp
778: where per.business_group_id = bgp.business_group_id
779: and per.person_id = c_person_id
780: and c_effective_date between per.effective_start_date and per.effective_END_date;
781:

Line 893: FROM per_business_groups pbg,

889: IS
890: --
891: CURSOR legsel (p_assignment_id IN NUMBER, p_effective_date IN DATE) IS
892: SELECT pbg.legislation_code
893: FROM per_business_groups pbg,
894: per_assignments_f asg
895: WHERE pbg.business_group_id = asg.business_group_id
896: AND asg.assignment_id = p_assignment_id
897: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_END_date;

Line 899: l_legislation_code per_business_groups.legislation_code%type;

895: WHERE pbg.business_group_id = asg.business_group_id
896: AND asg.assignment_id = p_assignment_id
897: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_END_date;
898: --
899: l_legislation_code per_business_groups.legislation_code%type;
900: --
901: BEGIN
902:
903: OPEN legsel(p_assignment_id, trunc(p_effective_date));

Line 964: FROM per_business_groups pbg,

960:
961: --
962: CURSOR legsel IS
963: SELECT pbg.legislation_code
964: FROM per_business_groups pbg,
965: pay_personal_payment_methods_f ppm
966: WHERE pbg.business_group_id = ppm.business_group_id
967: AND ppm.personal_payment_method_id = p_personal_payment_method_id
968: AND p_effective_date BETWEEN ppm.effective_start_date AND ppm.effective_END_date;

Line 970: l_legislation_code per_business_groups.legislation_code%type;

966: WHERE pbg.business_group_id = ppm.business_group_id
967: AND ppm.personal_payment_method_id = p_personal_payment_method_id
968: AND p_effective_date BETWEEN ppm.effective_start_date AND ppm.effective_END_date;
969: --
970: l_legislation_code per_business_groups.legislation_code%type;
971:
972: BEGIN
973:
974: OPEN legsel;