eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NO_EOY_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 215: FROM hr_organization_information

211: ,lg_format_mask OUT NOCOPY VARCHAR2) IS
212: -- Cursor to retrieve Currency
213: CURSOR csr_currency IS
214: SELECT org_information10
215: FROM hr_organization_information
216: WHERE organization_id = p_business_group_id
217: AND org_information_context = 'Business Group Information';
218: --
219: l_currency VARCHAR2(40);

Line 651: ,hr_organization_information hoi

647: ,greatest( trunc(p_effective_date,'Y'), paf.effective_start_date) start_date
648: ,least( p_effective_date, paf.effective_end_date) end_date
649: FROM per_all_assignments_f paf
650: ,hr_soft_coding_keyflex sck
651: ,hr_organization_information hoi
652: ,per_assignment_status_types pas
653: WHERE paf.person_id = p_person_id
654: AND sck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
655: AND pas.assignment_status_type_id = paf.assignment_status_type_id

Line 751: ,hr_organization_information hoi

747: SELECT greatest( trunc(p_effective_date,'Y'), paf.effective_start_date) start_date
748: ,least( p_effective_date, paf.effective_end_date) end_date
749: FROM per_all_assignments_f paf
750: ,hr_soft_coding_keyflex sck
751: ,hr_organization_information hoi
752: ,per_assignment_status_types pas
753: WHERE paf.person_id = p_person_id
754: AND sck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
755: AND pas.assignment_status_type_id = paf.assignment_status_type_id

Line 1053: ,hr_organization_information hoi1

1049: ,hoi2.org_information1 organization_number
1050: ,TO_NUMBER(hoi2.org_information5) tax_office_id
1051: ,hoi2.org_information2 tax_municipality
1052: FROM hr_all_organization_units org
1053: ,hr_organization_information hoi1
1054: ,hr_organization_information hoi2
1055: WHERE p_legal_employer_id IS NULL
1056: AND org.business_group_id = p_business_group_id
1057: AND hoi1.organization_id = org.organization_id

Line 1054: ,hr_organization_information hoi2

1050: ,TO_NUMBER(hoi2.org_information5) tax_office_id
1051: ,hoi2.org_information2 tax_municipality
1052: FROM hr_all_organization_units org
1053: ,hr_organization_information hoi1
1054: ,hr_organization_information hoi2
1055: WHERE p_legal_employer_id IS NULL
1056: AND org.business_group_id = p_business_group_id
1057: AND hoi1.organization_id = org.organization_id
1058: AND hoi1.org_information_context = 'CLASS'

Line 1069: ,hr_organization_information hoi1

1065: ,hoi1.org_information1 organization_number
1066: ,TO_NUMBER(hoi1.org_information5) tax_office_id
1067: ,hoi1.org_information2 tax_municipality
1068: FROM hr_all_organization_units org
1069: ,hr_organization_information hoi1
1070: WHERE p_legal_employer_id IS NOT NULL
1071: AND org.organization_id = p_legal_employer_id
1072: AND hoi1.organization_id (+) = org.organization_id
1073: AND hoi1.org_information_context (+) = 'NO_LEGAL_EMPLOYER_DETAILS';

Line 1079: CURSOR csr_Legal_Emp_EA(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE

1075: -- Cursor to Extract Other subsidis received (to reduce excemption limit),
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

Line 1084: ,hr_organization_information hoi1

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
1088: AND hoi1.organization_id = csr_v_legal_emp_id

Line 1085: ,hr_organization_information hoi2

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
1088: AND hoi1.organization_id = csr_v_legal_emp_id
1089: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1097: CURSOR csr_Legal_Emp_PP(csr_v_legal_emp_id hr_organization_information.organization_id%TYPE

1093: AND p_report_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information2)
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

Line 1103: ,hr_organization_information hoi1

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
1107: AND hoi1.organization_id = o1.organization_id

Line 1104: ,hr_organization_information hoi2

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
1107: AND hoi1.organization_id = o1.organization_id
1108: AND hoi1.organization_id = csr_v_legal_emp_id

Line 1141: ,hr_organization_information hoi

1137: ,nvl(DECODE(hoi.org_information14,'PROCEDURE' , hoi.org_information15),
1138: decode(hoi.org_information14, 'PROCEDURE', hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_SUMM_DFN'))) rep_summ_dfn
1139: FROM pay_user_tables t
1140: ,pay_user_rows_f r
1141: ,hr_organization_information hoi
1142: WHERE t.user_table_name = 'NO_EOY_CODE_REPORTING_RULES'
1143: AND t.legislation_code = 'NO'
1144: AND r.user_table_id = t.user_table_id
1145: AND r.row_low_range_or_name = hoi.org_information3(+)

Line 1190: ,hr_organization_information hoi

1186: FROM pay_user_rows_f r
1187: ,pay_user_tables t
1188: ,pay_user_columns c
1189: ,pay_user_column_instances_f ci
1190: ,hr_organization_information hoi
1191: WHERE t.user_table_name = 'NO_EOY_CODE_REPORTING_RULES'
1192: AND c.user_table_id = t.user_table_id
1193: AND r.user_table_id = t.user_table_id
1194: AND ci.user_row_id = r.user_row_id

Line 1235: ,hr_organization_information orginf1

1231: ,pay_action_contexts pac2
1232: ,ff_contexts ctx1
1233: ,ff_contexts ctx2
1234: ,hr_lookups lu
1235: ,hr_organization_information orginf1
1236: ,hr_all_organization_units org2
1237: ,hr_organization_information orginf2
1238: ,pay_user_tables t
1239: ,pay_user_rows_f r

Line 1237: ,hr_organization_information orginf2

1233: ,ff_contexts ctx2
1234: ,hr_lookups lu
1235: ,hr_organization_information orginf1
1236: ,hr_all_organization_units org2
1237: ,hr_organization_information orginf2
1238: ,pay_user_tables t
1239: ,pay_user_rows_f r
1240: WHERE ppa.business_group_id = p_business_group_id
1241: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1282: Cursor csr_LE_Contact ( csr_v_legal_emp_id hr_organization_information.organization_id%TYPE) IS

1278: AND paa.tax_unit_id = p_legal_employer_id
1279: AND ppa.date_earned BETWEEN TRUNC(p_report_date, 'Y') AND p_report_date;
1280: --
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

Line 1286: ,hr_organization_information hoi1

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
1290: AND hoi1.organization_id = o1.organization_id

Line 1287: ,hr_organization_information hoi2

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
1290: AND hoi1.organization_id = o1.organization_id
1291: AND hoi1.organization_id = csr_v_legal_emp_id

Line 1288: ,hr_organization_information hoi3

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
1290: AND hoi1.organization_id = o1.organization_id
1291: AND hoi1.organization_id = csr_v_legal_emp_id
1292: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'