APPS.EAM_ASSIGN_EMP_PUB dependencies on HR_GENERAL

Line 571: AND pce.business_group_id = HR_GENERAL.GET_BUSINESS_GROUP_ID

567:
568: SELECT count(1) INTO l_count_competence
569: FROM PER_COMPETENCE_ELEMENTS pce
570: WHERE pce.person_id = p_person_id
571: AND pce.business_group_id = HR_GENERAL.GET_BUSINESS_GROUP_ID
572: AND pce.type = 'PERSONAL'
573: AND pce.competence_id = p_competence_id
574: AND ( pce.effective_date_from IS NULL
575: OR trunc(sysdate) >= pce.effective_date_from

Line 607: AND pce.business_group_id = HR_GENERAL.GET_BUSINESS_GROUP_ID

603: SELECT COUNT(1) INTO l_count_competence_type
604: FROM PER_COMPETENCE_ELEMENTS pce,
605: PER_COMPETENCE_ELEMENTS pce1
606: WHERE pce.person_id = p_person_id
607: AND pce.business_group_id = HR_GENERAL.GET_BUSINESS_GROUP_ID
608: AND pce.type = 'PERSONAL'
609: AND pce.competence_id = pce1.competence_id
610: AND (pce.effective_date_from IS NULL
611: OR trunc(sysdate) >= pce.effective_date_from

Line 695: AND ppf.business_group_id = HR_GENERAL.GET_BUSINESS_GROUP_ID

691: OR bre.person_id = p_person_id)
692: AND bre.person_id = ppf.person_id
693: AND ppf.effective_start_date <= sysdate
694: AND ppf.effective_end_date > sysdate
695: AND ppf.business_group_id = HR_GENERAL.GET_BUSINESS_GROUP_ID
696: AND ( ppf.current_employee_flag is null
697: OR ppf.current_employee_flag = 'Y' )
698: AND ( p_competence_id IS NULL OR p_competence_id IN
699: ( SELECT competence_id

Line 702: AND pce.business_group_id = HR_GENERAL.GET_BUSINESS_GROUP_ID

698: AND ( p_competence_id IS NULL OR p_competence_id IN
699: ( SELECT competence_id
700: FROM PER_COMPETENCE_ELEMENTS pce
701: WHERE pce.person_id = ppf.person_id
702: AND pce.business_group_id = HR_GENERAL.GET_BUSINESS_GROUP_ID
703: AND pce.type = 'PERSONAL'
704: AND pce.competence_id = p_competence_id
705: AND ( pce.effective_date_from IS NULL OR trunc(sysdate) >= pce.effective_date_from )
706: AND ( pce.effective_date_to IS NULL OR trunc(sysdate) < pce.effective_date_to)

Line 713: AND pce.business_group_id = HR_GENERAL.GET_BUSINESS_GROUP_ID

709: AND ( p_competence_type IS NULL OR p_competence_type IN
710: ( SELECT pce1.competence_type
711: FROM PER_COMPETENCE_ELEMENTS pce, PER_COMPETENCE_ELEMENTS pce1
712: WHERE pce.person_id = ppf.person_id
713: AND pce.business_group_id = HR_GENERAL.GET_BUSINESS_GROUP_ID
714: AND pce.type = 'PERSONAL'
715: AND pce.competence_id = pce1.competence_id
716: AND (pce.effective_date_from IS NULL OR trunc(sysdate) >= pce.effective_date_from )
717: AND (pce.effective_date_to IS NULL OR trunc(sysdate) < pce.effective_date_to )

Line 917: --msg('inside search_pvt = ' || HR_GENERAL.GET_BUSINESS_GROUP_ID);

913: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
914:
915:
916: BEGIN
917: --msg('inside search_pvt = ' || HR_GENERAL.GET_BUSINESS_GROUP_ID);
918: --msg(' wip_entity_id ==>' || p_wip_entity_id);
919: --msg( 'p_operation_seq_num ==>' || p_operation_seq_num);
920: --msg(' p_resource_seq_num ==>' || p_resource_seq_num);
921: --msg(' p_organization_id ==>' || p_organization_id);

Line 1347: AND ppf.business_group_id = HR_GENERAL.GET_BUSINESS_GROUP_ID

1343: eam_work_order_details ewod,
1344: bom_resource_employees bre,
1345: per_people_f ppf
1346: WHERE ppf.person_id = p_person_id
1347: AND ppf.business_group_id = HR_GENERAL.GET_BUSINESS_GROUP_ID
1348: AND ppf.EFFECTIVE_START_DATE <= sysdate
1349: AND ppf.EFFECTIVE_END_DATE > sysdate
1350: AND bre.person_id = ppf.person_id
1351: AND bre.effective_start_date <= sysdate