APPS.HR_BIS_ALERTS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 827: , hr_all_organization_units o

823: --
824: CURSOR sg_cur(p_organization_id IN VARCHAR2) IS
825: SELECT b.security_group_id
826: FROM per_business_groups b
827: , hr_all_organization_units o
828: where o.business_group_id = b.business_group_id
829: AND o.organization_id = p_organization_id;
830:
831: BEGIN

Line 862: ,p_organization_id IN hr_all_organization_units.organization_id%TYPE)

858: -------------------------------------------------------------------------
859: FUNCTION validate_resp_org_security
860: (p_responsibility_id IN fnd_responsibility.responsibility_id%TYPE
861: ,p_application_id IN fnd_responsibility.application_id%TYPE
862: ,p_organization_id IN hr_all_organization_units.organization_id%TYPE)
863: RETURN BOOLEAN
864: IS
865:
866: l_dummy NUMBER;

Line 1185: FROM hr_all_organization_units

1181: CURSOR c_bg_id
1182: (p_c_org_id NUMBER)
1183: IS
1184: SELECT business_group_id
1185: FROM hr_all_organization_units
1186: WHERE sysdate
1187: BETWEEN date_from
1188: AND nvl(date_to, hr_general.end_of_time)
1189: AND organization_id = p_c_org_id;

Line 1191: l_business_group_id hr_all_organization_units.business_group_id%TYPE;

1187: BETWEEN date_from
1188: AND nvl(date_to, hr_general.end_of_time)
1189: AND organization_id = p_c_org_id;
1190:
1191: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
1192:
1193: BEGIN
1194:
1195: pl('*Get Org Business Group id','Start');

Line 1308: l_business_group_id hr_all_organization_units.business_group_id%TYPE;

1304: l_error VARCHAR2(2000);
1305:
1306: -- Session params
1307: l_security_group_id per_business_groups.security_group_id%TYPE;
1308: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
1309: l_resp_id fnd_responsibility.responsibility_id%TYPE;
1310: l_resp_short_name bisfv_targets.notify_resp1_short_name%TYPE;
1311: l_resp_name bisfv_targets.notify_resp1_name%TYPE;
1312: l_resp_appl_id fnd_responsibility.application_id%TYPE;

Line 1759: l_business_group_id hr_all_organization_units.business_group_id%TYPE;

1755: l_period_name VARCHAR2(50);
1756:
1757: -- Session params
1758: l_security_group_id per_business_groups.security_group_id%TYPE;
1759: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
1760: l_resp_id fnd_responsibility.responsibility_id%TYPE;
1761: l_resp_short_name bisfv_targets.notify_resp1_short_name%TYPE;
1762: l_resp_name bisfv_targets.notify_resp1_name%TYPE;
1763: l_resp_appl_id fnd_responsibility.application_id%TYPE;

Line 2404: l_business_group_id hr_all_organization_units.business_group_id%TYPE;

2400: l_period_name VARCHAR2(50);
2401:
2402: -- Session params
2403: l_security_group_id per_business_groups.security_group_id%TYPE;
2404: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
2405: l_resp_id fnd_responsibility.responsibility_id%TYPE;
2406: l_resp_short_name bisfv_targets.notify_resp1_short_name%TYPE;
2407: l_resp_name bisfv_targets.notify_resp1_name%TYPE;
2408: l_resp_appl_id fnd_responsibility.application_id%TYPE;

Line 2909: l_business_group_id hr_all_organization_units.business_group_id%TYPE;

2905: l_period_name VARCHAR2(50);
2906:
2907: -- Session params
2908: l_security_group_id per_business_groups.security_group_id%TYPE;
2909: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
2910: l_resp_id fnd_responsibility.responsibility_id%TYPE;
2911: l_resp_short_name bisfv_targets.notify_resp1_short_name%TYPE;
2912: l_resp_name bisfv_targets.notify_resp1_name%TYPE;
2913: l_resp_appl_id fnd_responsibility.application_id%TYPE;