APPS.PAY_NO_EOY_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 1080: ,csr_v_business_group_id hr_organization_units.business_group_id%TYPE

1076: -- same as in bi-monthly recording sheet, but total for the year (2007/08 changes)
1077: --
1078:
1079: CURSOR csr_Legal_Emp_EA(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE
1080: ,csr_v_business_group_id hr_organization_units.business_group_id%TYPE
1081: ,p_report_date DATE) IS
1082: SELECT to_number(hoi2.org_information4) economic_aid
1083: FROM hr_organization_units o1
1084: ,hr_organization_information hoi1

Line 1083: FROM hr_organization_units o1

1079: CURSOR csr_Legal_Emp_EA(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE
1080: ,csr_v_business_group_id hr_organization_units.business_group_id%TYPE
1081: ,p_report_date DATE) IS
1082: SELECT to_number(hoi2.org_information4) economic_aid
1083: FROM hr_organization_units o1
1084: ,hr_organization_information hoi1
1085: ,hr_organization_information hoi2
1086: WHERE o1.business_group_id = csr_v_business_group_id
1087: AND hoi1.organization_id = o1.organization_id

Line 1098: ,csr_v_business_group_id hr_organization_units.business_group_id%TYPE

1094: AND fnd_date.canonical_to_date(hoi2.org_information3);
1095: ---- Bug#9579261 fix starts
1096:
1097: CURSOR csr_Legal_Emp_PP(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE
1098: ,csr_v_business_group_id hr_organization_units.business_group_id%TYPE
1099: ,p_report_date DATE) IS
1100: SELECT hoi2.org_information3 pen_scheme
1101: ,hoi2.org_information4 pp_id
1102: FROM hr_organization_units o1

Line 1102: FROM hr_organization_units o1

1098: ,csr_v_business_group_id hr_organization_units.business_group_id%TYPE
1099: ,p_report_date DATE) IS
1100: SELECT hoi2.org_information3 pen_scheme
1101: ,hoi2.org_information4 pp_id
1102: FROM hr_organization_units o1
1103: ,hr_organization_information hoi1
1104: ,hr_organization_information hoi2
1105: ,hr_organization_units o2
1106: WHERE o1.business_group_id = csr_v_business_group_id

Line 1105: ,hr_organization_units o2

1101: ,hoi2.org_information4 pp_id
1102: FROM hr_organization_units o1
1103: ,hr_organization_information hoi1
1104: ,hr_organization_information hoi2
1105: ,hr_organization_units o2
1106: WHERE o1.business_group_id = csr_v_business_group_id
1107: AND hoi1.organization_id = o1.organization_id
1108: AND hoi1.organization_id = csr_v_legal_emp_id
1109: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1116: CURSOR csr_pp_name(csr_v_pp_id hr_organization_units.organization_id%TYPE) IS

1112: AND hoi2.org_information_context ='NO_PENSION_PROVIDER'
1113: AND p_report_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information1)
1114: AND fnd_date.canonical_to_date(hoi2.org_information2);
1115:
1116: CURSOR csr_pp_name(csr_v_pp_id hr_organization_units.organization_id%TYPE) IS
1117: SELECT o1.name name
1118: FROM hr_organization_units o1
1119: where o1.organization_id = csr_v_pp_id;
1120: ---- Bug#9579261 fix ends

Line 1118: FROM hr_organization_units o1

1114: AND fnd_date.canonical_to_date(hoi2.org_information2);
1115:
1116: CURSOR csr_pp_name(csr_v_pp_id hr_organization_units.organization_id%TYPE) IS
1117: SELECT o1.name name
1118: FROM hr_organization_units o1
1119: where o1.organization_id = csr_v_pp_id;
1120: ---- Bug#9579261 fix ends
1121: --
1122:

Line 1285: FROM hr_organization_units o1

1281: --Bug 14671801
1282: Cursor csr_LE_Contact ( csr_v_legal_emp_id hr_organization_information.organization_id%TYPE) IS
1283: SELECT hoi2.org_information2 email
1284: ,hoi3.org_information2 phone
1285: FROM hr_organization_units o1
1286: ,hr_organization_information hoi1
1287: ,hr_organization_information hoi2
1288: ,hr_organization_information hoi3
1289: WHERE o1.business_group_id = g_business_group_id