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.PER_IN_ORG_INFO_LEG_HOOK dependencies on HR_ORGANIZATION_INFORMATION

Line 214: l_org_info hr_organization_information.org_information1%type;

210: l_bus_numb_pf VARCHAR2(1);
211: l_challan_ref_no VARCHAR2(1);
212: l_chq_dd_no VARCHAR2(1);
213: l_pf_bnk_brnch_dtls VARCHAR2(1);
214: l_org_info hr_organization_information.org_information1%type;
215: l_procedure VARCHAR2(100);
216: l_message VARCHAR2(300);
217:
218: CURSOR chk_unique_reg (p_org_info VARCHAR2) IS

Line 220: FROM hr_organization_information

216: l_message VARCHAR2(300);
217:
218: CURSOR chk_unique_reg (p_org_info VARCHAR2) IS
219: SELECT 'X'
220: FROM hr_organization_information
221: WHERE org_information_context = 'IN_CONTRACTOR_INFO'
222: AND org_information1 = p_org_info;
223:
224: CURSOR chk_unique_license (p_org_info VARCHAR2) IS

Line 226: FROM hr_organization_information

222: AND org_information1 = p_org_info;
223:
224: CURSOR chk_unique_license (p_org_info VARCHAR2) IS
225: SELECT 'X'
226: FROM hr_organization_information
227: WHERE org_information_context = 'IN_CONTRACTOR_INFO'
228: AND org_information2 = p_org_info;
229:
230: CURSOR chk_unique_pf (p_org_info VARCHAR2) IS

Line 232: FROM hr_organization_information

228: AND org_information2 = p_org_info;
229:
230: CURSOR chk_unique_pf (p_org_info VARCHAR2) IS
231: SELECT 'X'
232: FROM hr_organization_information
233: WHERE org_information_context = 'IN_CONTRACTOR_INFO'
234: AND org_information3 = p_org_info;
235:
236: CURSOR chk_unique_esi (p_org_info VARCHAR2) IS

Line 238: FROM hr_organization_information

234: AND org_information3 = p_org_info;
235:
236: CURSOR chk_unique_esi (p_org_info VARCHAR2) IS
237: SELECT 'X'
238: FROM hr_organization_information
239: WHERE org_information_context = 'IN_CONTRACTOR_INFO'
240: AND org_information4 = p_org_info;
241:
242: CURSOR chk_unique_pan (p_org_info VARCHAR2) IS

Line 244: FROM hr_organization_information

240: AND org_information4 = p_org_info;
241:
242: CURSOR chk_unique_pan (p_org_info VARCHAR2) IS
243: SELECT 'X'
244: FROM hr_organization_information
245: WHERE org_information_context = 'IN_CONTRACTOR_INFO'
246: AND org_information5 = p_org_info;
247:
248: CURSOR chk_unique_ref_no (p_org_info VARCHAR2, p_organization_id NUMBER, p_org_information6 VARCHAR2) IS

Line 250: FROM hr_organization_information

246: AND org_information5 = p_org_info;
247:
248: CURSOR chk_unique_ref_no (p_org_info VARCHAR2, p_organization_id NUMBER, p_org_information6 VARCHAR2) IS
249: SELECT 'X'
250: FROM hr_organization_information
251: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
252: AND organization_id = p_organization_id
253: AND org_information6 = p_org_information6
254: AND org_information3 = p_org_info;

Line 258: FROM hr_organization_information

254: AND org_information3 = p_org_info;
255:
256: CURSOR chk_unique_receipt_no (p_org_info VARCHAR2, p_organization_id NUMBER, p_org_information6 VARCHAR2) IS
257: SELECT 'X'
258: FROM hr_organization_information
259: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
260: AND organization_id = p_organization_id
261: AND org_information6 = p_org_information6
262: AND org_information4 = p_org_info;

Line 266: FROM hr_organization_information

262: AND org_information4 = p_org_info;
263:
264: CURSOR chk_unique_bus_no_pf (p_org_info VARCHAR2) IS
265: SELECT 'X'
266: FROM hr_organization_information
267: WHERE org_information_context = 'PER_IN_COMPANY_DF'
268: AND org_information5 = p_org_info;
269:
270: CURSOR chk_unique_chn_no_pf (p_org_info VARCHAR2) IS

Line 272: FROM hr_organization_information

268: AND org_information5 = p_org_info;
269:
270: CURSOR chk_unique_chn_no_pf (p_org_info VARCHAR2) IS
271: SELECT 'X'
272: FROM hr_organization_information
273: WHERE org_information_context = 'PER_IN_PF_CHALLAN_INFO'
274: AND org_information12 = p_org_info;
275:
276: CURSOR chk_unq_chn_no_pf_7q (p_org_info VARCHAR2) IS

Line 278: FROM hr_organization_information

274: AND org_information12 = p_org_info;
275:
276: CURSOR chk_unq_chn_no_pf_7q (p_org_info VARCHAR2) IS
277: SELECT 'X'
278: FROM hr_organization_information
279: WHERE org_information_context = 'PER_IN_PF_SEC7Q_INFO'
280: AND org_information11 = p_org_info;
281:
282: CURSOR chk_unq_chn_no_pf_14b (p_org_info VARCHAR2) IS

Line 284: FROM hr_organization_information

280: AND org_information11 = p_org_info;
281:
282: CURSOR chk_unq_chn_no_pf_14b (p_org_info VARCHAR2) IS
283: SELECT 'X'
284: FROM hr_organization_information
285: WHERE org_information_context = 'PER_IN_PF_CHN_SEC14B'
286: AND org_information1 = p_org_info;
287:
288: CURSOR chk_unq_chn_no_pf_oth (p_org_info VARCHAR2,p_org_info_type_code varchar2) IS

Line 290: FROM hr_organization_information

286: AND org_information1 = p_org_info;
287:
288: CURSOR chk_unq_chn_no_pf_oth (p_org_info VARCHAR2,p_org_info_type_code varchar2) IS
289: SELECT 'X'
290: FROM hr_organization_information
291: WHERE org_information_context = p_org_info_type_code
292: AND org_information3 = p_org_info;
293:
294: CURSOR chk_unique_chq_no_pf (p_org_info VARCHAR2) IS

Line 296: FROM hr_organization_information

292: AND org_information3 = p_org_info;
293:
294: CURSOR chk_unique_chq_no_pf (p_org_info VARCHAR2) IS
295: SELECT 'X'
296: FROM hr_organization_information
297: WHERE org_information_context = 'PER_IN_PF_BANK_PAYMENT_DETAILS'
298: AND org_information5 = p_org_info;
299:
300: CURSOR chk_unq_chn_bnk_brnch_dtls IS

Line 302: FROM hr_organization_information

298: AND org_information5 = p_org_info;
299:
300: CURSOR chk_unq_chn_bnk_brnch_dtls IS
301: SELECT 'X'
302: FROM hr_organization_information
303: WHERE org_information_context = 'PER_IN_PF_BANK_BRANCH_DTLS'
304: AND org_information1 = p_org_information1
305: AND org_information2 = p_org_information2
306: AND organization_id = p_organization_id;

Line 719: l_org_info hr_organization_information.org_information1%type;

715: l_receipt_num VARCHAR2(1);
716: l_ref_num VARCHAR2(1);
717: l_challan_ref_no VARCHAR2(1);
718: l_pf_bnk_brnch_dtls VARCHAR2(1);
719: l_org_info hr_organization_information.org_information1%type;
720: l_chq_dd_no VARCHAR2(1);
721: l_procedure VARCHAR2(100);
722: l_message VARCHAR2(300);
723:

Line 727: FROM hr_organization_information

723:
724:
725: CURSOR chk_unique_reg (p_org_info VARCHAR2) IS
726: SELECT 'X'
727: FROM hr_organization_information
728: WHERE org_information_context = 'IN_CONTRACTOR_INFO'
729: AND org_information1 = p_org_info
730: AND org_information_id <> p_org_information_id;
731:

Line 734: FROM hr_organization_information

730: AND org_information_id <> p_org_information_id;
731:
732: CURSOR chk_unique_license (p_org_info VARCHAR2) IS
733: SELECT 'X'
734: FROM hr_organization_information
735: WHERE org_information_context = 'IN_CONTRACTOR_INFO'
736: AND org_information2 = p_org_info
737: AND org_information_id <> p_org_information_id;
738:

Line 741: FROM hr_organization_information

737: AND org_information_id <> p_org_information_id;
738:
739: CURSOR chk_unique_pf (p_org_info VARCHAR2) IS
740: SELECT 'X'
741: FROM hr_organization_information
742: WHERE org_information_context = 'IN_CONTRACTOR_INFO'
743: AND org_information3 = p_org_info
744: AND org_information_id <> p_org_information_id;
745:

Line 748: FROM hr_organization_information

744: AND org_information_id <> p_org_information_id;
745:
746: CURSOR chk_unique_esi (p_org_info VARCHAR2) IS
747: SELECT 'X'
748: FROM hr_organization_information
749: WHERE org_information_context = 'IN_CONTRACTOR_INFO'
750: AND org_information4 = p_org_info
751: AND org_information_id <> p_org_information_id;
752:

Line 755: FROM hr_organization_information

751: AND org_information_id <> p_org_information_id;
752:
753: CURSOR chk_unique_pan (p_org_info VARCHAR2) IS
754: SELECT 'X'
755: FROM hr_organization_information
756: WHERE org_information_context = 'IN_CONTRACTOR_INFO'
757: AND org_information5 = p_org_info
758: AND org_information_id <> p_org_information_id;
759:

Line 762: FROM hr_organization_information

758: AND org_information_id <> p_org_information_id;
759:
760: CURSOR chk_unique_ref_no (p_org_info VARCHAR2, p_organization_id NUMBER, p_org_information6 VARCHAR2) IS
761: SELECT 'X'
762: FROM hr_organization_information
763: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
764: AND org_information3 = p_org_info
765: AND org_information6 = p_org_information6
766: AND organization_id = p_organization_id

Line 772: FROM hr_organization_information

768:
769:
770: CURSOR chk_unique_receipt_no (p_org_info VARCHAR2, p_organization_id NUMBER, p_org_information6 VARCHAR2) IS
771: SELECT 'X'
772: FROM hr_organization_information
773: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
774: AND org_information4 = p_org_info
775: AND org_information6 = p_org_information6
776: AND organization_id = p_organization_id

Line 781: FROM hr_organization_information

777: AND org_information_id <> p_org_information_id;
778:
779: CURSOR chk_unique_bus_no_pf (p_org_info VARCHAR2) IS
780: SELECT 'X'
781: FROM hr_organization_information
782: WHERE org_information_context = 'PER_IN_COMPANY_DF'
783: AND org_information5 = p_org_info
784: AND org_information_id <> p_org_information_id;
785:

Line 788: FROM hr_organization_information

784: AND org_information_id <> p_org_information_id;
785:
786: CURSOR chk_unique_chn_no_pf (p_org_info VARCHAR2) IS
787: SELECT 'X'
788: FROM hr_organization_information
789: WHERE org_information_context = 'PER_IN_PF_CHALLAN_INFO'
790: AND org_information12 = p_org_info
791: AND org_information_id <> p_org_information_id;
792:

Line 795: FROM hr_organization_information

791: AND org_information_id <> p_org_information_id;
792:
793: CURSOR chk_unq_chn_no_pf_7q (p_org_info VARCHAR2) IS
794: SELECT 'X'
795: FROM hr_organization_information
796: WHERE org_information_context = 'PER_IN_PF_SEC7Q_INFO'
797: AND org_information11 = p_org_info
798: AND org_information_id <> p_org_information_id;
799:

Line 803: FROM hr_organization_information

799:
800:
801: CURSOR chk_unq_chn_no_pf_14b (p_org_info VARCHAR2) IS
802: SELECT 'X'
803: FROM hr_organization_information
804: WHERE org_information_context = 'PER_IN_PF_CHN_SEC14B'
805: AND org_information1 = p_org_info
806: AND org_information_id <> p_org_information_id;
807:

Line 810: FROM hr_organization_information

806: AND org_information_id <> p_org_information_id;
807:
808: CURSOR chk_unq_chn_no_pf_oth (p_org_info VARCHAR2,p_org_info_type_code varchar2) IS
809: SELECT 'X'
810: FROM hr_organization_information
811: WHERE org_information_context = p_org_info_type_code
812: AND org_information3 = p_org_info
813: AND org_information_id <> p_org_information_id;
814:

Line 817: FROM hr_organization_information

813: AND org_information_id <> p_org_information_id;
814:
815: CURSOR chk_unique_chq_no_pf (p_org_info VARCHAR2) IS
816: SELECT 'X'
817: FROM hr_organization_information
818: WHERE org_information_context = 'PER_IN_PF_BANK_PAYMENT_DETAILS'
819: AND org_information5 = p_org_info
820: AND org_information_id <> p_org_information_id;
821:

Line 824: FROM hr_organization_information

820: AND org_information_id <> p_org_information_id;
821:
822: CURSOR chk_unq_chn_bnk_brnch_dtls IS
823: SELECT 'X'
824: FROM hr_organization_information
825: WHERE org_information_context = 'PER_IN_PF_BANK_BRANCH_DTLS'
826: AND org_information1 = p_org_information1
827: AND org_information2 = p_org_information2
828: AND org_information_id <> p_org_information_id

Line 1384: FROM hr_organization_information

1380: -- with that of any other organization
1381: ------------------------------------------------------------------
1382: CURSOR chk_unique_tan IS
1383: SELECT 'X'
1384: FROM hr_organization_information
1385: WHERE org_information_context = 'PER_IN_INCOME_TAX_DF'
1386: AND org_information1 = p_org_information1
1387: AND organization_id<>p_organization_id;
1388:

Line 1397: FROM hr_organization_information hoi

1393: -------------------------------------------------------------------
1394: CURSOR chk_date_overlap_rep_ins(p_start_date DATE
1395: ,p_end_date DATE)IS
1396: SELECT 'X'
1397: FROM hr_organization_information hoi
1398: WHERE p_start_date <=nvl(fnd_date.canonical_to_date(hoi.org_information3),to_date('4712/12/31','YYYY/MM/DD'))
1399: AND nvl(p_end_date,to_date('4712/12/31','YYYY/MM/DD')) >=fnd_date.canonical_to_date(hoi.org_information2)
1400: AND organization_id=p_organization_id
1401: AND org_information_context=p_org_info_type_code;

Line 1410: FROM hr_organization_information bank

1406: ------------------------------------------------------------------
1407: CURSOR c_bsr_code
1408: IS
1409: SELECT bank.org_information4
1410: FROM hr_organization_information bank
1411: WHERE bank.org_information_context = 'PER_IN_CHALLAN_BANK'
1412: AND p_org_information5 = bank.org_information_id ;
1413:
1414: CURSOR chk_unique_challan(p_bsr_code VARCHAR2) IS

Line 1417: ,hr_organization_information hoi

1413:
1414: CURSOR chk_unique_challan(p_bsr_code VARCHAR2) IS
1415: SELECT 'X'
1416: FROM hr_organization_units hou
1417: ,hr_organization_information hoi
1418: WHERE hoi.organization_id = hou.organization_id
1419: AND hou.business_group_id = (SELECT business_group_id
1420: FROM hr_organization_units org
1421: WHERE org.organization_id = p_organization_id)

Line 1428: ,hr_organization_information bank

1424: AND hoi.org_information2= p_org_information2
1425: and ((p_org_information5 is not null and
1426: p_bsr_code in (SELECT bank.org_information4
1427: FROM hr_organization_units hou
1428: ,hr_organization_information bank
1429: WHERE hoi.organization_id = hou.organization_id
1430: AND hou.business_group_id = (SELECT business_group_id
1431: FROM hr_organization_units org
1432: WHERE org.organization_id = p_organization_id)

Line 1856: FROM hr_organization_information

1852: -- other organisation.
1853: --
1854: CURSOR chk_unique_tan (p_organization_id NUMBER) IS
1855: SELECT 'X'
1856: FROM hr_organization_information
1857: WHERE org_information_context = 'PER_IN_INCOME_TAX_DF'
1858: AND org_information1 = p_org_information1
1859: AND organization_id <>p_organization_id;
1860:

Line 1866: FROM hr_organization_information

1862: -- Cursor to get the organization id
1863: --
1864: CURSOR csr_organization_id IS
1865: SELECT organization_id
1866: FROM hr_organization_information
1867: WHERE org_information_id =p_org_information_id;
1868:
1869:
1870: --

Line 1878: FROM hr_organization_information hoi

1874: CURSOR chk_date_overlap_rep_upd(p_organization_id NUMBER
1875: ,p_start_date DATE
1876: ,p_end_date DATE) IS
1877: SELECT 'X'
1878: FROM hr_organization_information hoi
1879: WHERE p_start_date <=nvl(fnd_date.canonical_to_date(hoi.org_information3),to_date('4712/12/31','YYYY/MM/DD'))
1880: AND nvl(p_end_date,to_date('4712/12/31','YYYY/MM/DD')) >=fnd_date.canonical_to_date(hoi.org_information2)
1881: AND organization_id=p_organization_id
1882: AND org_information_id <>p_org_information_id

Line 1888: FROM hr_organization_information bank

1884:
1885: CURSOR c_bsr_code
1886: is
1887: SELECT bank.org_information4
1888: FROM hr_organization_information bank
1889: WHERE bank.org_information_context = 'PER_IN_CHALLAN_BANK'
1890: AND p_org_information5 = bank.org_information_id ;
1891:
1892:

Line 1900: ,hr_organization_information hoi

1896: ,p_organization_id NUMBER
1897: ,p_bsr_code VARCHAR2) IS
1898: SELECT 'X'
1899: FROM hr_organization_units hou
1900: ,hr_organization_information hoi
1901: WHERE hoi.organization_id = hou.organization_id
1902: AND hou.business_group_id = (SELECT business_group_id
1903: FROM hr_organization_units org
1904: WHERE org.organization_id = p_organization_id)

Line 1909: ,hr_organization_information bank

1905: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
1906: and ((p_org_information5 is not null and
1907: p_bsr_code in (SELECT bank.org_information4
1908: FROM hr_organization_units hou
1909: ,hr_organization_information bank
1910: WHERE hoi.organization_id = hou.organization_id
1911: AND hou.business_group_id = (SELECT business_group_id
1912: FROM hr_organization_units org
1913: WHERE org.organization_id = p_organization_id)

Line 3174: FROM hr_organization_information hoi

3170: IS
3171: CURSOR csr_employer_type
3172: IS
3173: SELECT org_information6
3174: FROM hr_organization_information hoi
3175: WHERE hoi.organization_id =p_organization_id
3176: AND hoi.org_information_context ='PER_IN_INCOME_TAX_DF';
3177:
3178: CURSOR csr_orig_check(p_org_information1 VARCHAR2

Line 3183: FROM hr_organization_information

3179: , p_org_information2 VARCHAR2
3180: , p_org_information_id NUMBER)
3181: IS
3182: SELECT COUNT(*)
3183: FROM hr_organization_information
3184: WHERE organization_id = p_organization_id
3185: AND org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
3186: AND org_information1 = p_org_information1
3187: AND org_information2 = p_org_information2

Line 3198: FROM hr_organization_information

3194: CURSOR csr_correction_check(p_org_information1 VARCHAR2
3195: , p_org_information2 VARCHAR2)
3196: IS
3197: SELECT COUNT(*)
3198: FROM hr_organization_information
3199: WHERE organization_id = p_organization_id
3200: AND org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
3201: AND org_information1 = p_org_information1
3202: AND org_information2 = p_org_information2

Line 3215: FROM hr_organization_information hoi

3211: SELECT 'Y'
3212: FROM DUAL
3213: WHERE EXISTS
3214: ( SELECT 1
3215: FROM hr_organization_information hoi
3216: ,pay_element_entries_f pee
3217: ,pay_element_types_f pet
3218: WHERE pet.element_name = 'Income Tax Challan Information'
3219: AND pet.legislation_code = 'IN'

Line 3229: l_emlpr_type hr_organization_information.org_information3%TYPE;

3225: AND (hoi.org_information3 <> p_org_information3 OR hoi.org_information2 <> p_org_information2)
3226: );
3227:
3228:
3229: l_emlpr_type hr_organization_information.org_information3%TYPE;
3230: l_book_entry_allowed VARCHAR2(1);
3231: l_procedure VARCHAR2(100);
3232: l_message VARCHAR2(300);
3233: l_receipt_count NUMBER;

Line 4163: FROM hr_organization_information

4159: ,org_information17
4160: ,org_information18
4161: ,org_information19
4162: ,org_information20
4163: FROM hr_organization_information
4164: WHERE org_information_id = p_org_information_id;
4165:
4166: l_organization_id hr_organization_information.organization_id%TYPE;
4167: l_org_information1 hr_organization_information.org_information1%TYPE;

Line 4166: l_organization_id hr_organization_information.organization_id%TYPE;

4162: ,org_information20
4163: FROM hr_organization_information
4164: WHERE org_information_id = p_org_information_id;
4165:
4166: l_organization_id hr_organization_information.organization_id%TYPE;
4167: l_org_information1 hr_organization_information.org_information1%TYPE;
4168: l_org_information2 hr_organization_information.org_information2%TYPE;
4169: l_org_information3 hr_organization_information.org_information3%TYPE;
4170: l_org_information4 hr_organization_information.org_information4%TYPE;

Line 4167: l_org_information1 hr_organization_information.org_information1%TYPE;

4163: FROM hr_organization_information
4164: WHERE org_information_id = p_org_information_id;
4165:
4166: l_organization_id hr_organization_information.organization_id%TYPE;
4167: l_org_information1 hr_organization_information.org_information1%TYPE;
4168: l_org_information2 hr_organization_information.org_information2%TYPE;
4169: l_org_information3 hr_organization_information.org_information3%TYPE;
4170: l_org_information4 hr_organization_information.org_information4%TYPE;
4171: l_org_information5 hr_organization_information.org_information5%TYPE;

Line 4168: l_org_information2 hr_organization_information.org_information2%TYPE;

4164: WHERE org_information_id = p_org_information_id;
4165:
4166: l_organization_id hr_organization_information.organization_id%TYPE;
4167: l_org_information1 hr_organization_information.org_information1%TYPE;
4168: l_org_information2 hr_organization_information.org_information2%TYPE;
4169: l_org_information3 hr_organization_information.org_information3%TYPE;
4170: l_org_information4 hr_organization_information.org_information4%TYPE;
4171: l_org_information5 hr_organization_information.org_information5%TYPE;
4172: l_org_information6 hr_organization_information.org_information6%TYPE;

Line 4169: l_org_information3 hr_organization_information.org_information3%TYPE;

4165:
4166: l_organization_id hr_organization_information.organization_id%TYPE;
4167: l_org_information1 hr_organization_information.org_information1%TYPE;
4168: l_org_information2 hr_organization_information.org_information2%TYPE;
4169: l_org_information3 hr_organization_information.org_information3%TYPE;
4170: l_org_information4 hr_organization_information.org_information4%TYPE;
4171: l_org_information5 hr_organization_information.org_information5%TYPE;
4172: l_org_information6 hr_organization_information.org_information6%TYPE;
4173: l_org_information7 hr_organization_information.org_information7%TYPE;

Line 4170: l_org_information4 hr_organization_information.org_information4%TYPE;

4166: l_organization_id hr_organization_information.organization_id%TYPE;
4167: l_org_information1 hr_organization_information.org_information1%TYPE;
4168: l_org_information2 hr_organization_information.org_information2%TYPE;
4169: l_org_information3 hr_organization_information.org_information3%TYPE;
4170: l_org_information4 hr_organization_information.org_information4%TYPE;
4171: l_org_information5 hr_organization_information.org_information5%TYPE;
4172: l_org_information6 hr_organization_information.org_information6%TYPE;
4173: l_org_information7 hr_organization_information.org_information7%TYPE;
4174: l_org_information8 hr_organization_information.org_information8%TYPE;

Line 4171: l_org_information5 hr_organization_information.org_information5%TYPE;

4167: l_org_information1 hr_organization_information.org_information1%TYPE;
4168: l_org_information2 hr_organization_information.org_information2%TYPE;
4169: l_org_information3 hr_organization_information.org_information3%TYPE;
4170: l_org_information4 hr_organization_information.org_information4%TYPE;
4171: l_org_information5 hr_organization_information.org_information5%TYPE;
4172: l_org_information6 hr_organization_information.org_information6%TYPE;
4173: l_org_information7 hr_organization_information.org_information7%TYPE;
4174: l_org_information8 hr_organization_information.org_information8%TYPE;
4175: l_org_information9 hr_organization_information.org_information9%TYPE;

Line 4172: l_org_information6 hr_organization_information.org_information6%TYPE;

4168: l_org_information2 hr_organization_information.org_information2%TYPE;
4169: l_org_information3 hr_organization_information.org_information3%TYPE;
4170: l_org_information4 hr_organization_information.org_information4%TYPE;
4171: l_org_information5 hr_organization_information.org_information5%TYPE;
4172: l_org_information6 hr_organization_information.org_information6%TYPE;
4173: l_org_information7 hr_organization_information.org_information7%TYPE;
4174: l_org_information8 hr_organization_information.org_information8%TYPE;
4175: l_org_information9 hr_organization_information.org_information9%TYPE;
4176: l_org_information10 hr_organization_information.org_information10%TYPE;

Line 4173: l_org_information7 hr_organization_information.org_information7%TYPE;

4169: l_org_information3 hr_organization_information.org_information3%TYPE;
4170: l_org_information4 hr_organization_information.org_information4%TYPE;
4171: l_org_information5 hr_organization_information.org_information5%TYPE;
4172: l_org_information6 hr_organization_information.org_information6%TYPE;
4173: l_org_information7 hr_organization_information.org_information7%TYPE;
4174: l_org_information8 hr_organization_information.org_information8%TYPE;
4175: l_org_information9 hr_organization_information.org_information9%TYPE;
4176: l_org_information10 hr_organization_information.org_information10%TYPE;
4177: l_org_information11 hr_organization_information.org_information11%TYPE;

Line 4174: l_org_information8 hr_organization_information.org_information8%TYPE;

4170: l_org_information4 hr_organization_information.org_information4%TYPE;
4171: l_org_information5 hr_organization_information.org_information5%TYPE;
4172: l_org_information6 hr_organization_information.org_information6%TYPE;
4173: l_org_information7 hr_organization_information.org_information7%TYPE;
4174: l_org_information8 hr_organization_information.org_information8%TYPE;
4175: l_org_information9 hr_organization_information.org_information9%TYPE;
4176: l_org_information10 hr_organization_information.org_information10%TYPE;
4177: l_org_information11 hr_organization_information.org_information11%TYPE;
4178: l_org_information12 hr_organization_information.org_information12%TYPE;

Line 4175: l_org_information9 hr_organization_information.org_information9%TYPE;

4171: l_org_information5 hr_organization_information.org_information5%TYPE;
4172: l_org_information6 hr_organization_information.org_information6%TYPE;
4173: l_org_information7 hr_organization_information.org_information7%TYPE;
4174: l_org_information8 hr_organization_information.org_information8%TYPE;
4175: l_org_information9 hr_organization_information.org_information9%TYPE;
4176: l_org_information10 hr_organization_information.org_information10%TYPE;
4177: l_org_information11 hr_organization_information.org_information11%TYPE;
4178: l_org_information12 hr_organization_information.org_information12%TYPE;
4179: l_org_information13 hr_organization_information.org_information13%TYPE;

Line 4176: l_org_information10 hr_organization_information.org_information10%TYPE;

4172: l_org_information6 hr_organization_information.org_information6%TYPE;
4173: l_org_information7 hr_organization_information.org_information7%TYPE;
4174: l_org_information8 hr_organization_information.org_information8%TYPE;
4175: l_org_information9 hr_organization_information.org_information9%TYPE;
4176: l_org_information10 hr_organization_information.org_information10%TYPE;
4177: l_org_information11 hr_organization_information.org_information11%TYPE;
4178: l_org_information12 hr_organization_information.org_information12%TYPE;
4179: l_org_information13 hr_organization_information.org_information13%TYPE;
4180: l_org_information14 hr_organization_information.org_information14%TYPE;

Line 4177: l_org_information11 hr_organization_information.org_information11%TYPE;

4173: l_org_information7 hr_organization_information.org_information7%TYPE;
4174: l_org_information8 hr_organization_information.org_information8%TYPE;
4175: l_org_information9 hr_organization_information.org_information9%TYPE;
4176: l_org_information10 hr_organization_information.org_information10%TYPE;
4177: l_org_information11 hr_organization_information.org_information11%TYPE;
4178: l_org_information12 hr_organization_information.org_information12%TYPE;
4179: l_org_information13 hr_organization_information.org_information13%TYPE;
4180: l_org_information14 hr_organization_information.org_information14%TYPE;
4181: l_org_information15 hr_organization_information.org_information15%TYPE;

Line 4178: l_org_information12 hr_organization_information.org_information12%TYPE;

4174: l_org_information8 hr_organization_information.org_information8%TYPE;
4175: l_org_information9 hr_organization_information.org_information9%TYPE;
4176: l_org_information10 hr_organization_information.org_information10%TYPE;
4177: l_org_information11 hr_organization_information.org_information11%TYPE;
4178: l_org_information12 hr_organization_information.org_information12%TYPE;
4179: l_org_information13 hr_organization_information.org_information13%TYPE;
4180: l_org_information14 hr_organization_information.org_information14%TYPE;
4181: l_org_information15 hr_organization_information.org_information15%TYPE;
4182: l_org_information16 hr_organization_information.org_information16%TYPE;

Line 4179: l_org_information13 hr_organization_information.org_information13%TYPE;

4175: l_org_information9 hr_organization_information.org_information9%TYPE;
4176: l_org_information10 hr_organization_information.org_information10%TYPE;
4177: l_org_information11 hr_organization_information.org_information11%TYPE;
4178: l_org_information12 hr_organization_information.org_information12%TYPE;
4179: l_org_information13 hr_organization_information.org_information13%TYPE;
4180: l_org_information14 hr_organization_information.org_information14%TYPE;
4181: l_org_information15 hr_organization_information.org_information15%TYPE;
4182: l_org_information16 hr_organization_information.org_information16%TYPE;
4183: l_org_information17 hr_organization_information.org_information17%TYPE;

Line 4180: l_org_information14 hr_organization_information.org_information14%TYPE;

4176: l_org_information10 hr_organization_information.org_information10%TYPE;
4177: l_org_information11 hr_organization_information.org_information11%TYPE;
4178: l_org_information12 hr_organization_information.org_information12%TYPE;
4179: l_org_information13 hr_organization_information.org_information13%TYPE;
4180: l_org_information14 hr_organization_information.org_information14%TYPE;
4181: l_org_information15 hr_organization_information.org_information15%TYPE;
4182: l_org_information16 hr_organization_information.org_information16%TYPE;
4183: l_org_information17 hr_organization_information.org_information17%TYPE;
4184: l_org_information18 hr_organization_information.org_information18%TYPE;

Line 4181: l_org_information15 hr_organization_information.org_information15%TYPE;

4177: l_org_information11 hr_organization_information.org_information11%TYPE;
4178: l_org_information12 hr_organization_information.org_information12%TYPE;
4179: l_org_information13 hr_organization_information.org_information13%TYPE;
4180: l_org_information14 hr_organization_information.org_information14%TYPE;
4181: l_org_information15 hr_organization_information.org_information15%TYPE;
4182: l_org_information16 hr_organization_information.org_information16%TYPE;
4183: l_org_information17 hr_organization_information.org_information17%TYPE;
4184: l_org_information18 hr_organization_information.org_information18%TYPE;
4185: l_org_information19 hr_organization_information.org_information19%TYPE;

Line 4182: l_org_information16 hr_organization_information.org_information16%TYPE;

4178: l_org_information12 hr_organization_information.org_information12%TYPE;
4179: l_org_information13 hr_organization_information.org_information13%TYPE;
4180: l_org_information14 hr_organization_information.org_information14%TYPE;
4181: l_org_information15 hr_organization_information.org_information15%TYPE;
4182: l_org_information16 hr_organization_information.org_information16%TYPE;
4183: l_org_information17 hr_organization_information.org_information17%TYPE;
4184: l_org_information18 hr_organization_information.org_information18%TYPE;
4185: l_org_information19 hr_organization_information.org_information19%TYPE;
4186: l_org_information20 hr_organization_information.org_information20%TYPE;

Line 4183: l_org_information17 hr_organization_information.org_information17%TYPE;

4179: l_org_information13 hr_organization_information.org_information13%TYPE;
4180: l_org_information14 hr_organization_information.org_information14%TYPE;
4181: l_org_information15 hr_organization_information.org_information15%TYPE;
4182: l_org_information16 hr_organization_information.org_information16%TYPE;
4183: l_org_information17 hr_organization_information.org_information17%TYPE;
4184: l_org_information18 hr_organization_information.org_information18%TYPE;
4185: l_org_information19 hr_organization_information.org_information19%TYPE;
4186: l_org_information20 hr_organization_information.org_information20%TYPE;
4187:

Line 4184: l_org_information18 hr_organization_information.org_information18%TYPE;

4180: l_org_information14 hr_organization_information.org_information14%TYPE;
4181: l_org_information15 hr_organization_information.org_information15%TYPE;
4182: l_org_information16 hr_organization_information.org_information16%TYPE;
4183: l_org_information17 hr_organization_information.org_information17%TYPE;
4184: l_org_information18 hr_organization_information.org_information18%TYPE;
4185: l_org_information19 hr_organization_information.org_information19%TYPE;
4186: l_org_information20 hr_organization_information.org_information20%TYPE;
4187:
4188: l_procedure VARCHAR2(100);

Line 4185: l_org_information19 hr_organization_information.org_information19%TYPE;

4181: l_org_information15 hr_organization_information.org_information15%TYPE;
4182: l_org_information16 hr_organization_information.org_information16%TYPE;
4183: l_org_information17 hr_organization_information.org_information17%TYPE;
4184: l_org_information18 hr_organization_information.org_information18%TYPE;
4185: l_org_information19 hr_organization_information.org_information19%TYPE;
4186: l_org_information20 hr_organization_information.org_information20%TYPE;
4187:
4188: l_procedure VARCHAR2(100);
4189: l_message VARCHAR2(300);

Line 4186: l_org_information20 hr_organization_information.org_information20%TYPE;

4182: l_org_information16 hr_organization_information.org_information16%TYPE;
4183: l_org_information17 hr_organization_information.org_information17%TYPE;
4184: l_org_information18 hr_organization_information.org_information18%TYPE;
4185: l_org_information19 hr_organization_information.org_information19%TYPE;
4186: l_org_information20 hr_organization_information.org_information20%TYPE;
4187:
4188: l_procedure VARCHAR2(100);
4189: l_message VARCHAR2(300);
4190: