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 1373: FROM hr_organization_information

1369: -- with that of any other organization
1370: ------------------------------------------------------------------
1371: CURSOR chk_unique_tan IS
1372: SELECT 'X'
1373: FROM hr_organization_information
1374: WHERE org_information_context = 'PER_IN_INCOME_TAX_DF'
1375: AND org_information1 = p_org_information1
1376: AND organization_id<>p_organization_id;
1377:

Line 1386: FROM hr_organization_information hoi

1382: -------------------------------------------------------------------
1383: CURSOR chk_date_overlap_rep_ins(p_start_date DATE
1384: ,p_end_date DATE)IS
1385: SELECT 'X'
1386: FROM hr_organization_information hoi
1387: WHERE p_start_date <=nvl(fnd_date.canonical_to_date(hoi.org_information3),to_date('4712/12/31','YYYY/MM/DD'))
1388: AND nvl(p_end_date,to_date('4712/12/31','YYYY/MM/DD')) >=fnd_date.canonical_to_date(hoi.org_information2)
1389: AND organization_id=p_organization_id
1390: AND org_information_context=p_org_info_type_code;

Line 1399: FROM hr_organization_information hoi

1395: ------------------------------------------------------------------
1396:
1397: CURSOR chk_unique_challan IS
1398: SELECT 'X'
1399: FROM hr_organization_information hoi
1400: ,hr_organization_units hou
1401: WHERE hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
1402: AND hoi.org_information3 = p_org_information3
1403: AND hou.organization_id = hoi.organization_id

Line 1653: FROM hr_organization_information

1649: -- other organisation.
1650: --
1651: CURSOR chk_unique_tan (p_organization_id NUMBER) IS
1652: SELECT 'X'
1653: FROM hr_organization_information
1654: WHERE org_information_context = 'PER_IN_INCOME_TAX_DF'
1655: AND org_information1 = p_org_information1
1656: AND organization_id <>p_organization_id;
1657:

Line 1663: FROM hr_organization_information

1659: -- Cursor to get the organization id
1660: --
1661: CURSOR csr_organization_id IS
1662: SELECT organization_id
1663: FROM hr_organization_information
1664: WHERE org_information_id =p_org_information_id;
1665:
1666:
1667: --

Line 1675: FROM hr_organization_information hoi

1671: CURSOR chk_date_overlap_rep_upd(p_organization_id NUMBER
1672: ,p_start_date DATE
1673: ,p_end_date DATE) IS
1674: SELECT 'X'
1675: FROM hr_organization_information hoi
1676: WHERE p_start_date <=nvl(fnd_date.canonical_to_date(hoi.org_information3),to_date('4712/12/31','YYYY/MM/DD'))
1677: AND nvl(p_end_date,to_date('4712/12/31','YYYY/MM/DD')) >=fnd_date.canonical_to_date(hoi.org_information2)
1678: AND organization_id=p_organization_id
1679: AND org_information_id <>p_org_information_id

Line 1685: FROM hr_organization_information hoi

1681:
1682: CURSOR chk_unique_challan(p_challan_number VARCHAR2
1683: ,p_organization_id NUMBER) IS
1684: SELECT 'X'
1685: FROM hr_organization_information hoi
1686: ,hr_organization_units hou
1687: WHERE hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
1688: AND hoi.org_information3 = p_challan_number
1689: AND hoi.org_information_id <> p_org_information_id

Line 2784: FROM hr_organization_information hoi

2780: IS
2781: CURSOR csr_employer_type
2782: IS
2783: SELECT org_information3
2784: FROM hr_organization_information hoi
2785: WHERE hoi.organization_id =p_organization_id
2786: AND hoi.org_information_context ='PER_IN_INCOME_TAX_DF';
2787:
2788: CURSOR csr_orig_check(p_org_information1 VARCHAR2

Line 2793: FROM hr_organization_information

2789: , p_org_information2 VARCHAR2
2790: , p_org_information_id NUMBER)
2791: IS
2792: SELECT COUNT(*)
2793: FROM hr_organization_information
2794: WHERE organization_id = p_organization_id
2795: AND org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
2796: AND org_information1 = p_org_information1
2797: AND org_information2 = p_org_information2

Line 2808: FROM hr_organization_information

2804: CURSOR csr_correction_check(p_org_information1 VARCHAR2
2805: , p_org_information2 VARCHAR2)
2806: IS
2807: SELECT COUNT(*)
2808: FROM hr_organization_information
2809: WHERE organization_id = p_organization_id
2810: AND org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
2811: AND org_information1 = p_org_information1
2812: AND org_information2 = p_org_information2

Line 2824: FROM hr_organization_information hoi

2820: SELECT 'Y'
2821: FROM DUAL
2822: WHERE EXISTS
2823: ( SELECT 1
2824: FROM hr_organization_information hoi
2825: ,pay_element_entries_f pee
2826: ,pay_element_types_f pet
2827: WHERE pet.element_name = 'Income Tax Challan Information'
2828: AND pet.legislation_code = 'IN'

Line 2839: l_emlpr_type hr_organization_information.org_information3%TYPE;

2835: );
2836:
2837:
2838:
2839: l_emlpr_type hr_organization_information.org_information3%TYPE;
2840: l_book_entry_allowed VARCHAR2(1);
2841: l_procedure VARCHAR2(100);
2842: l_message VARCHAR2(300);
2843: l_receipt_count NUMBER;

Line 3757: FROM hr_organization_information

3753: ,org_information17
3754: ,org_information18
3755: ,org_information19
3756: ,org_information20
3757: FROM hr_organization_information
3758: WHERE org_information_id = p_org_information_id;
3759:
3760: l_organization_id hr_organization_information.organization_id%TYPE;
3761: l_org_information1 hr_organization_information.org_information1%TYPE;

Line 3760: l_organization_id hr_organization_information.organization_id%TYPE;

3756: ,org_information20
3757: FROM hr_organization_information
3758: WHERE org_information_id = p_org_information_id;
3759:
3760: l_organization_id hr_organization_information.organization_id%TYPE;
3761: l_org_information1 hr_organization_information.org_information1%TYPE;
3762: l_org_information2 hr_organization_information.org_information2%TYPE;
3763: l_org_information3 hr_organization_information.org_information3%TYPE;
3764: l_org_information4 hr_organization_information.org_information4%TYPE;

Line 3761: l_org_information1 hr_organization_information.org_information1%TYPE;

3757: FROM hr_organization_information
3758: WHERE org_information_id = p_org_information_id;
3759:
3760: l_organization_id hr_organization_information.organization_id%TYPE;
3761: l_org_information1 hr_organization_information.org_information1%TYPE;
3762: l_org_information2 hr_organization_information.org_information2%TYPE;
3763: l_org_information3 hr_organization_information.org_information3%TYPE;
3764: l_org_information4 hr_organization_information.org_information4%TYPE;
3765: l_org_information5 hr_organization_information.org_information5%TYPE;

Line 3762: l_org_information2 hr_organization_information.org_information2%TYPE;

3758: WHERE org_information_id = p_org_information_id;
3759:
3760: l_organization_id hr_organization_information.organization_id%TYPE;
3761: l_org_information1 hr_organization_information.org_information1%TYPE;
3762: l_org_information2 hr_organization_information.org_information2%TYPE;
3763: l_org_information3 hr_organization_information.org_information3%TYPE;
3764: l_org_information4 hr_organization_information.org_information4%TYPE;
3765: l_org_information5 hr_organization_information.org_information5%TYPE;
3766: l_org_information6 hr_organization_information.org_information6%TYPE;

Line 3763: l_org_information3 hr_organization_information.org_information3%TYPE;

3759:
3760: l_organization_id hr_organization_information.organization_id%TYPE;
3761: l_org_information1 hr_organization_information.org_information1%TYPE;
3762: l_org_information2 hr_organization_information.org_information2%TYPE;
3763: l_org_information3 hr_organization_information.org_information3%TYPE;
3764: l_org_information4 hr_organization_information.org_information4%TYPE;
3765: l_org_information5 hr_organization_information.org_information5%TYPE;
3766: l_org_information6 hr_organization_information.org_information6%TYPE;
3767: l_org_information7 hr_organization_information.org_information7%TYPE;

Line 3764: l_org_information4 hr_organization_information.org_information4%TYPE;

3760: l_organization_id hr_organization_information.organization_id%TYPE;
3761: l_org_information1 hr_organization_information.org_information1%TYPE;
3762: l_org_information2 hr_organization_information.org_information2%TYPE;
3763: l_org_information3 hr_organization_information.org_information3%TYPE;
3764: l_org_information4 hr_organization_information.org_information4%TYPE;
3765: l_org_information5 hr_organization_information.org_information5%TYPE;
3766: l_org_information6 hr_organization_information.org_information6%TYPE;
3767: l_org_information7 hr_organization_information.org_information7%TYPE;
3768: l_org_information8 hr_organization_information.org_information8%TYPE;

Line 3765: l_org_information5 hr_organization_information.org_information5%TYPE;

3761: l_org_information1 hr_organization_information.org_information1%TYPE;
3762: l_org_information2 hr_organization_information.org_information2%TYPE;
3763: l_org_information3 hr_organization_information.org_information3%TYPE;
3764: l_org_information4 hr_organization_information.org_information4%TYPE;
3765: l_org_information5 hr_organization_information.org_information5%TYPE;
3766: l_org_information6 hr_organization_information.org_information6%TYPE;
3767: l_org_information7 hr_organization_information.org_information7%TYPE;
3768: l_org_information8 hr_organization_information.org_information8%TYPE;
3769: l_org_information9 hr_organization_information.org_information9%TYPE;

Line 3766: l_org_information6 hr_organization_information.org_information6%TYPE;

3762: l_org_information2 hr_organization_information.org_information2%TYPE;
3763: l_org_information3 hr_organization_information.org_information3%TYPE;
3764: l_org_information4 hr_organization_information.org_information4%TYPE;
3765: l_org_information5 hr_organization_information.org_information5%TYPE;
3766: l_org_information6 hr_organization_information.org_information6%TYPE;
3767: l_org_information7 hr_organization_information.org_information7%TYPE;
3768: l_org_information8 hr_organization_information.org_information8%TYPE;
3769: l_org_information9 hr_organization_information.org_information9%TYPE;
3770: l_org_information10 hr_organization_information.org_information10%TYPE;

Line 3767: l_org_information7 hr_organization_information.org_information7%TYPE;

3763: l_org_information3 hr_organization_information.org_information3%TYPE;
3764: l_org_information4 hr_organization_information.org_information4%TYPE;
3765: l_org_information5 hr_organization_information.org_information5%TYPE;
3766: l_org_information6 hr_organization_information.org_information6%TYPE;
3767: l_org_information7 hr_organization_information.org_information7%TYPE;
3768: l_org_information8 hr_organization_information.org_information8%TYPE;
3769: l_org_information9 hr_organization_information.org_information9%TYPE;
3770: l_org_information10 hr_organization_information.org_information10%TYPE;
3771: l_org_information11 hr_organization_information.org_information11%TYPE;

Line 3768: l_org_information8 hr_organization_information.org_information8%TYPE;

3764: l_org_information4 hr_organization_information.org_information4%TYPE;
3765: l_org_information5 hr_organization_information.org_information5%TYPE;
3766: l_org_information6 hr_organization_information.org_information6%TYPE;
3767: l_org_information7 hr_organization_information.org_information7%TYPE;
3768: l_org_information8 hr_organization_information.org_information8%TYPE;
3769: l_org_information9 hr_organization_information.org_information9%TYPE;
3770: l_org_information10 hr_organization_information.org_information10%TYPE;
3771: l_org_information11 hr_organization_information.org_information11%TYPE;
3772: l_org_information12 hr_organization_information.org_information12%TYPE;

Line 3769: l_org_information9 hr_organization_information.org_information9%TYPE;

3765: l_org_information5 hr_organization_information.org_information5%TYPE;
3766: l_org_information6 hr_organization_information.org_information6%TYPE;
3767: l_org_information7 hr_organization_information.org_information7%TYPE;
3768: l_org_information8 hr_organization_information.org_information8%TYPE;
3769: l_org_information9 hr_organization_information.org_information9%TYPE;
3770: l_org_information10 hr_organization_information.org_information10%TYPE;
3771: l_org_information11 hr_organization_information.org_information11%TYPE;
3772: l_org_information12 hr_organization_information.org_information12%TYPE;
3773: l_org_information13 hr_organization_information.org_information13%TYPE;

Line 3770: l_org_information10 hr_organization_information.org_information10%TYPE;

3766: l_org_information6 hr_organization_information.org_information6%TYPE;
3767: l_org_information7 hr_organization_information.org_information7%TYPE;
3768: l_org_information8 hr_organization_information.org_information8%TYPE;
3769: l_org_information9 hr_organization_information.org_information9%TYPE;
3770: l_org_information10 hr_organization_information.org_information10%TYPE;
3771: l_org_information11 hr_organization_information.org_information11%TYPE;
3772: l_org_information12 hr_organization_information.org_information12%TYPE;
3773: l_org_information13 hr_organization_information.org_information13%TYPE;
3774: l_org_information14 hr_organization_information.org_information14%TYPE;

Line 3771: l_org_information11 hr_organization_information.org_information11%TYPE;

3767: l_org_information7 hr_organization_information.org_information7%TYPE;
3768: l_org_information8 hr_organization_information.org_information8%TYPE;
3769: l_org_information9 hr_organization_information.org_information9%TYPE;
3770: l_org_information10 hr_organization_information.org_information10%TYPE;
3771: l_org_information11 hr_organization_information.org_information11%TYPE;
3772: l_org_information12 hr_organization_information.org_information12%TYPE;
3773: l_org_information13 hr_organization_information.org_information13%TYPE;
3774: l_org_information14 hr_organization_information.org_information14%TYPE;
3775: l_org_information15 hr_organization_information.org_information15%TYPE;

Line 3772: l_org_information12 hr_organization_information.org_information12%TYPE;

3768: l_org_information8 hr_organization_information.org_information8%TYPE;
3769: l_org_information9 hr_organization_information.org_information9%TYPE;
3770: l_org_information10 hr_organization_information.org_information10%TYPE;
3771: l_org_information11 hr_organization_information.org_information11%TYPE;
3772: l_org_information12 hr_organization_information.org_information12%TYPE;
3773: l_org_information13 hr_organization_information.org_information13%TYPE;
3774: l_org_information14 hr_organization_information.org_information14%TYPE;
3775: l_org_information15 hr_organization_information.org_information15%TYPE;
3776: l_org_information16 hr_organization_information.org_information16%TYPE;

Line 3773: l_org_information13 hr_organization_information.org_information13%TYPE;

3769: l_org_information9 hr_organization_information.org_information9%TYPE;
3770: l_org_information10 hr_organization_information.org_information10%TYPE;
3771: l_org_information11 hr_organization_information.org_information11%TYPE;
3772: l_org_information12 hr_organization_information.org_information12%TYPE;
3773: l_org_information13 hr_organization_information.org_information13%TYPE;
3774: l_org_information14 hr_organization_information.org_information14%TYPE;
3775: l_org_information15 hr_organization_information.org_information15%TYPE;
3776: l_org_information16 hr_organization_information.org_information16%TYPE;
3777: l_org_information17 hr_organization_information.org_information17%TYPE;

Line 3774: l_org_information14 hr_organization_information.org_information14%TYPE;

3770: l_org_information10 hr_organization_information.org_information10%TYPE;
3771: l_org_information11 hr_organization_information.org_information11%TYPE;
3772: l_org_information12 hr_organization_information.org_information12%TYPE;
3773: l_org_information13 hr_organization_information.org_information13%TYPE;
3774: l_org_information14 hr_organization_information.org_information14%TYPE;
3775: l_org_information15 hr_organization_information.org_information15%TYPE;
3776: l_org_information16 hr_organization_information.org_information16%TYPE;
3777: l_org_information17 hr_organization_information.org_information17%TYPE;
3778: l_org_information18 hr_organization_information.org_information18%TYPE;

Line 3775: l_org_information15 hr_organization_information.org_information15%TYPE;

3771: l_org_information11 hr_organization_information.org_information11%TYPE;
3772: l_org_information12 hr_organization_information.org_information12%TYPE;
3773: l_org_information13 hr_organization_information.org_information13%TYPE;
3774: l_org_information14 hr_organization_information.org_information14%TYPE;
3775: l_org_information15 hr_organization_information.org_information15%TYPE;
3776: l_org_information16 hr_organization_information.org_information16%TYPE;
3777: l_org_information17 hr_organization_information.org_information17%TYPE;
3778: l_org_information18 hr_organization_information.org_information18%TYPE;
3779: l_org_information19 hr_organization_information.org_information19%TYPE;

Line 3776: l_org_information16 hr_organization_information.org_information16%TYPE;

3772: l_org_information12 hr_organization_information.org_information12%TYPE;
3773: l_org_information13 hr_organization_information.org_information13%TYPE;
3774: l_org_information14 hr_organization_information.org_information14%TYPE;
3775: l_org_information15 hr_organization_information.org_information15%TYPE;
3776: l_org_information16 hr_organization_information.org_information16%TYPE;
3777: l_org_information17 hr_organization_information.org_information17%TYPE;
3778: l_org_information18 hr_organization_information.org_information18%TYPE;
3779: l_org_information19 hr_organization_information.org_information19%TYPE;
3780: l_org_information20 hr_organization_information.org_information20%TYPE;

Line 3777: l_org_information17 hr_organization_information.org_information17%TYPE;

3773: l_org_information13 hr_organization_information.org_information13%TYPE;
3774: l_org_information14 hr_organization_information.org_information14%TYPE;
3775: l_org_information15 hr_organization_information.org_information15%TYPE;
3776: l_org_information16 hr_organization_information.org_information16%TYPE;
3777: l_org_information17 hr_organization_information.org_information17%TYPE;
3778: l_org_information18 hr_organization_information.org_information18%TYPE;
3779: l_org_information19 hr_organization_information.org_information19%TYPE;
3780: l_org_information20 hr_organization_information.org_information20%TYPE;
3781:

Line 3778: l_org_information18 hr_organization_information.org_information18%TYPE;

3774: l_org_information14 hr_organization_information.org_information14%TYPE;
3775: l_org_information15 hr_organization_information.org_information15%TYPE;
3776: l_org_information16 hr_organization_information.org_information16%TYPE;
3777: l_org_information17 hr_organization_information.org_information17%TYPE;
3778: l_org_information18 hr_organization_information.org_information18%TYPE;
3779: l_org_information19 hr_organization_information.org_information19%TYPE;
3780: l_org_information20 hr_organization_information.org_information20%TYPE;
3781:
3782: l_procedure VARCHAR2(100);

Line 3779: l_org_information19 hr_organization_information.org_information19%TYPE;

3775: l_org_information15 hr_organization_information.org_information15%TYPE;
3776: l_org_information16 hr_organization_information.org_information16%TYPE;
3777: l_org_information17 hr_organization_information.org_information17%TYPE;
3778: l_org_information18 hr_organization_information.org_information18%TYPE;
3779: l_org_information19 hr_organization_information.org_information19%TYPE;
3780: l_org_information20 hr_organization_information.org_information20%TYPE;
3781:
3782: l_procedure VARCHAR2(100);
3783: l_message VARCHAR2(300);

Line 3780: l_org_information20 hr_organization_information.org_information20%TYPE;

3776: l_org_information16 hr_organization_information.org_information16%TYPE;
3777: l_org_information17 hr_organization_information.org_information17%TYPE;
3778: l_org_information18 hr_organization_information.org_information18%TYPE;
3779: l_org_information19 hr_organization_information.org_information19%TYPE;
3780: l_org_information20 hr_organization_information.org_information20%TYPE;
3781:
3782: l_procedure VARCHAR2(100);
3783: l_message VARCHAR2(300);
3784: