APPS.HR_MISC_WEB dependencies on PER_BUSINESS_GROUPS

Line 963: RETURN per_business_groups.business_group_id%TYPE

959: */
960: FUNCTION get_business_group_id (
961: p_person_id IN per_people_f.person_id%TYPE
962: )
963: RETURN per_business_groups.business_group_id%TYPE
964: IS
965:
966: -- Local Variables.
967: l_person_rec per_people_f%ROWTYPE;

Line 985: RETURN per_business_groups.business_group_id%TYPE

981: END get_business_group_id;
982:
983:
984: FUNCTION get_business_group_id
985: RETURN per_business_groups.business_group_id%TYPE
986: IS
987:
988: -- Local Variables.
989: ln_business_group_id per_business_groups.business_group_id%TYPE;

Line 989: ln_business_group_id per_business_groups.business_group_id%TYPE;

985: RETURN per_business_groups.business_group_id%TYPE
986: IS
987:
988: -- Local Variables.
989: ln_business_group_id per_business_groups.business_group_id%TYPE;
990:
991: BEGIN
992:
993: fnd_profile.get (

Line 1023: p_business_group_id IN per_business_groups.business_group_id%TYPE

1019: */
1020: FUNCTION get_legislation_code (
1021: p_person_id IN per_people_f.person_id%TYPE DEFAULT NULL,
1022: p_assignment_id IN per_assignments_f.assignment_id%TYPE DEFAULT NULL,
1023: p_business_group_id IN per_business_groups.business_group_id%TYPE
1024: DEFAULT NULL,
1025: p_effective_date IN DATE DEFAULT SYSDATE
1026: )
1027: RETURN per_business_groups.legislation_code%TYPE

Line 1027: RETURN per_business_groups.legislation_code%TYPE

1023: p_business_group_id IN per_business_groups.business_group_id%TYPE
1024: DEFAULT NULL,
1025: p_effective_date IN DATE DEFAULT SYSDATE
1026: )
1027: RETURN per_business_groups.legislation_code%TYPE
1028: IS
1029:
1030: -- Local Variables.
1031: l_legislation_code VARCHAR2(150);

Line 1035: -- per_business_groups complex views. For better performance, they are

1031: l_legislation_code VARCHAR2(150);
1032:
1033: /* --------------------------------------------------------------------------
1034: -- The following cursors are commented out because they use the
1035: -- per_business_groups complex views. For better performance, they are
1036: -- replaced by base table which is hr_organization_information.
1037: --
1038: -- Avoid using join for better performance
1039: CURSOR csr_per_leg_code is

Line 1041: FROM per_business_groups pbg

1037: --
1038: -- Avoid using join for better performance
1039: CURSOR csr_per_leg_code is
1040: SELECT pbg.legislation_code
1041: FROM per_business_groups pbg
1042: WHERE pbg.business_group_id IN
1043: (SELECT per.business_group_id
1044: FROM per_all_people_f per
1045: WHERE per.person_id = p_person_id

Line 1051: FROM per_business_groups pbg

1047: AND NVL(per.effective_end_date, TRUNC(SYSDATE)));
1048:
1049: CURSOR csr_asg_leg_code is
1050: SELECT pbg.legislation_code
1051: FROM per_business_groups pbg
1052: WHERE pbg.business_group_id IN
1053: (SELECT paf.business_group_id
1054: FROM per_all_assignments_f paf
1055: WHERE paf.assignment_id = p_assignment_id

Line 1061: FROM per_business_groups

1057: AND NVL(paf.effective_end_date, TRUNC(SYSDATE)));
1058:
1059: CURSOR csr_bus_leg_code is
1060: SELECT legislation_code
1061: FROM per_business_groups
1062: WHERE business_group_id = p_business_group_id;
1063:
1064: -------------------------------------------------------------------------
1065: */