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_IN_24QC_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 476: l_deductor_type hr_organization_information.org_information3%TYPE;

472: l_token_value pay_in_utils.char_tab_type;
473: l_arch_ref_no_check NUMBER;
474: E_NON_UNIQUE_ARCH_REF_NO EXCEPTION;
475: E_EMPLR_CLASS_VALIDATE EXCEPTION;
476: l_deductor_type hr_organization_information.org_information3%TYPE;
477: l_tan_number hr_organization_information.org_information3%TYPE;
478: l_previous_deductor_type hr_organization_information.org_information3%TYPE;
479: --
480: BEGIN

Line 477: l_tan_number hr_organization_information.org_information3%TYPE;

473: l_arch_ref_no_check NUMBER;
474: E_NON_UNIQUE_ARCH_REF_NO EXCEPTION;
475: E_EMPLR_CLASS_VALIDATE EXCEPTION;
476: l_deductor_type hr_organization_information.org_information3%TYPE;
477: l_tan_number hr_organization_information.org_information3%TYPE;
478: l_previous_deductor_type hr_organization_information.org_information3%TYPE;
479: --
480: BEGIN
481: --

Line 478: l_previous_deductor_type hr_organization_information.org_information3%TYPE;

474: E_NON_UNIQUE_ARCH_REF_NO EXCEPTION;
475: E_EMPLR_CLASS_VALIDATE EXCEPTION;
476: l_deductor_type hr_organization_information.org_information3%TYPE;
477: l_tan_number hr_organization_information.org_information3%TYPE;
478: l_previous_deductor_type hr_organization_information.org_information3%TYPE;
479: --
480: BEGIN
481: --
482: g_debug := hr_utility.debug_enabled;

Line 539: FROM hr_organization_information hoi

535: RAISE E_NON_UNIQUE_ARCH_REF_NO;
536: END IF;
537:
538: SELECT hoi.org_information1 ,hoi.org_information6 into l_tan_number,l_deductor_type
539: FROM hr_organization_information hoi
540: ,hr_organization_units hou
541: WHERE hoi.organization_id = g_gre_id
542: AND hoi.org_information_context = 'PER_IN_INCOME_TAX_DF'
543: AND hou.organization_id = hoi.organization_id

Line 805: FROM hr_organization_information

801: AND pai.action_information15 = 'A'
802: AND pai.source_id = p_element_entry_id
803: AND paa_24qc.payroll_action_id IN(
804: SELECT org_information3
805: FROM hr_organization_information
806: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
807: AND organization_id = g_gre_id
808: AND org_information1 = g_year
809: AND org_information2 = g_quarter

Line 872: FROM hr_organization_information

868: AND pai.action_context_id = paa.assignment_action_id
869: AND(
870: paa.payroll_action_id IN (
871: SELECT org_information3
872: FROM hr_organization_information
873: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
874: AND organization_id = g_gre_id
875: AND org_information1 = g_year
876: AND org_information2 = g_quarter

Line 913: FROM hr_organization_information

909: AND masters.assignment_id = pai.assignment_id
910: AND masters.assignment_action_id = pai.action_context_id
911: AND masters.payroll_action_id IN(
912: SELECT org_information3
913: FROM hr_organization_information
914: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
915: AND organization_id = g_gre_id
916: AND org_information1 = g_year
917: AND org_information2 = g_quarter

Line 940: FROM hr_organization_information

936: AND masters.assignment_id = pai.assignment_id
937: AND masters.assignment_action_id = pai.action_context_id
938: AND masters.payroll_action_id IN(
939: SELECT org_information3
940: FROM hr_organization_information
941: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
942: AND organization_id = g_gre_id
943: AND org_information1 = g_year
944: AND org_information2 = g_quarter

Line 1002: FROM hr_organization_information

998: AND paa_24qc.assignment_id = pai.assignment_id
999: AND paa_24qc.assignment_action_id = pai.action_context_id
1000: AND paa_24qc.payroll_action_id IN(
1001: SELECT org_information3
1002: FROM hr_organization_information
1003: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
1004: AND organization_id = g_gre_id
1005: AND org_information1 = g_year
1006: AND org_information2 = g_quarter

Line 1030: FROM hr_organization_information

1026: AND paa_24qc.assignment_action_id = pai.action_context_id
1027: AND pai.source_id = entry.element_entry_id
1028: AND paa_24qc.payroll_action_id IN(
1029: SELECT org_information3
1030: FROM hr_organization_information
1031: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
1032: AND organization_id = g_gre_id
1033: AND org_information1 = g_year
1034: AND org_information2 = g_quarter

Line 1044: ,hr_organization_information hoi

1040: )
1041: AND pay_in_utils.get_ee_value(entry.element_entry_id,'Challan or Voucher Number') IN
1042: (SELECT bank.org_information4||' - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
1043: FROM hr_organization_units hou
1044: ,hr_organization_information hoi
1045: ,hr_organization_information bank
1046: WHERE hoi.organization_id = hou.organization_id
1047: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1048: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'

Line 1045: ,hr_organization_information bank

1041: AND pay_in_utils.get_ee_value(entry.element_entry_id,'Challan or Voucher Number') IN
1042: (SELECT bank.org_information4||' - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
1043: FROM hr_organization_units hou
1044: ,hr_organization_information hoi
1045: ,hr_organization_information bank
1046: WHERE hoi.organization_id = hou.organization_id
1047: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1048: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
1049: AND hoi.org_information1 = g_tax_year

Line 1058: ,hr_organization_information hoi

1054: AND hoi.organization_id = g_gre_id
1055: UNION
1056: SELECT 'BOOK - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
1057: FROM hr_organization_units hou
1058: ,hr_organization_information hoi
1059: WHERE hoi.organization_id = hou.organization_id
1060: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1061: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
1062: AND hoi.org_information1 = g_tax_year

Line 1084: ,hr_organization_information hoi

1080: AND action_information15 IN
1081: (
1082: (SELECT bank.org_information4||' - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
1083: FROM hr_organization_units hou
1084: ,hr_organization_information hoi
1085: ,hr_organization_information bank
1086: WHERE hoi.organization_id = hou.organization_id
1087: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1088: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'

Line 1085: ,hr_organization_information bank

1081: (
1082: (SELECT bank.org_information4||' - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
1083: FROM hr_organization_units hou
1084: ,hr_organization_information hoi
1085: ,hr_organization_information bank
1086: WHERE hoi.organization_id = hou.organization_id
1087: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1088: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
1089: AND hoi.org_information1 = g_tax_year

Line 1098: ,hr_organization_information hoi

1094: AND hoi.organization_id = g_gre_id
1095: UNION
1096: SELECT 'BOOK - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
1097: FROM hr_organization_units hou
1098: ,hr_organization_information hoi
1099: WHERE hoi.organization_id = hou.organization_id
1100: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1101: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
1102: AND hoi.org_information1 = g_tax_year

Line 1131: ,hr_organization_information hoi

1127: AND action_information2 = g_year||g_quarter
1128: AND action_information15 IN
1129: (SELECT bank.org_information4||' - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
1130: FROM hr_organization_units hou
1131: ,hr_organization_information hoi
1132: ,hr_organization_information bank
1133: WHERE hoi.organization_id = hou.organization_id
1134: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1135: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'

Line 1132: ,hr_organization_information bank

1128: AND action_information15 IN
1129: (SELECT bank.org_information4||' - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
1130: FROM hr_organization_units hou
1131: ,hr_organization_information hoi
1132: ,hr_organization_information bank
1133: WHERE hoi.organization_id = hou.organization_id
1134: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1135: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
1136: AND hoi.org_information1 = g_tax_year

Line 1145: ,hr_organization_information hoi

1141: AND hoi.organization_id = g_gre_id
1142: UNION
1143: SELECT 'BOOK - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
1144: FROM hr_organization_units hou
1145: ,hr_organization_information hoi
1146: WHERE hoi.organization_id = hou.organization_id
1147: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1148: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
1149: AND hoi.org_information1 = g_tax_year

Line 1249: FROM hr_organization_information

1245: AND pai_locking.action_context_id = paa.assignment_action_id
1246: AND paa.payroll_action_id IN
1247: (
1248: SELECT org_information3
1249: FROM hr_organization_information
1250: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
1251: AND organization_id = g_gre_id
1252: AND org_information1 = g_year
1253: AND org_information2 = g_quarter

Line 1278: FROM hr_organization_information

1274: AND pai.source_id = p_element_entry_id
1275: AND paa.payroll_action_id IN
1276: (
1277: SELECT org_information3
1278: FROM hr_organization_information
1279: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
1280: AND organization_id = g_gre_id
1281: AND org_information1 = g_year
1282: AND org_information2 = g_quarter

Line 1411: FROM hr_organization_information

1407: AND pai.action_context_id = paa.assignment_action_id
1408: AND paa.payroll_action_id IN
1409: (
1410: SELECT org_information3
1411: FROM hr_organization_information
1412: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
1413: AND organization_id = g_gre_id
1414: AND org_information1 = g_year
1415: AND org_information2 = g_quarter

Line 1435: FROM hr_organization_information

1431: AND pai.action_context_id = paa.assignment_action_id
1432: AND paa.payroll_action_id IN
1433: (
1434: SELECT org_information3
1435: FROM hr_organization_information
1436: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
1437: AND organization_id = g_gre_id
1438: AND org_information1 = g_year
1439: AND org_information2 = g_quarter

Line 1857: FROM hr_organization_information

1853: )
1854: AND(
1855: paa.payroll_action_id IN (
1856: SELECT org_information3
1857: FROM hr_organization_information
1858: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
1859: AND organization_id = g_gre_id
1860: AND org_information1 = g_year
1861: AND org_information2 = g_quarter

Line 1915: FROM hr_organization_information

1911: AND masters.assignment_id = pai.assignment_id
1912: AND masters.assignment_action_id = pai.action_context_id
1913: AND masters.payroll_action_id IN(
1914: SELECT org_information3
1915: FROM hr_organization_information
1916: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
1917: AND organization_id = g_gre_id
1918: AND org_information1 = g_year
1919: AND org_information2 = g_quarter

Line 1988: FROM hr_organization_information

1984: AND paa_24qc.assignment_id = pai.assignment_id
1985: AND paa_24qc.assignment_action_id = pai.action_context_id
1986: AND paa_24qc.payroll_action_id IN(
1987: SELECT org_information3
1988: FROM hr_organization_information
1989: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
1990: AND organization_id = g_gre_id
1991: AND org_information1 = g_year
1992: AND org_information2 = g_quarter

Line 2015: FROM hr_organization_information

2011: AND paa_24qc.assignment_id = pai.assignment_id
2012: AND paa_24qc.assignment_action_id = pai.action_context_id
2013: AND paa_24qc.payroll_action_id IN(
2014: SELECT org_information3
2015: FROM hr_organization_information
2016: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
2017: AND organization_id = g_gre_id
2018: AND org_information1 = g_year
2019: AND org_information2 = g_quarter

Line 2037: FROM hr_organization_information

2033: AND paa_24qc.assignment_id = pai.assignment_id
2034: AND paa_24qc.assignment_action_id = pai.action_context_id
2035: AND paa_24qc.payroll_action_id IN(
2036: SELECT org_information3
2037: FROM hr_organization_information
2038: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
2039: AND organization_id = g_gre_id
2040: AND org_information1 = g_year
2041: AND org_information2 = g_quarter

Line 2207: FROM hr_organization_information

2203: AND pai_locking.action_context_id = paa.assignment_action_id
2204: AND paa.payroll_action_id IN
2205: (
2206: SELECT org_information3
2207: FROM hr_organization_information
2208: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
2209: AND organization_id = g_gre_id
2210: AND org_information1 = g_year
2211: AND org_information2 = g_quarter

Line 2238: FROM hr_organization_information

2234: AND pai.source_id = p_source_id
2235: AND paa.payroll_action_id IN
2236: (
2237: SELECT org_information3
2238: FROM hr_organization_information
2239: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
2240: AND organization_id = g_gre_id
2241: AND org_information1 = g_year
2242: AND org_information2 = g_quarter

Line 2491: FROM hr_organization_information

2487: AND pai.action_context_id = paa.assignment_action_id
2488: AND paa.payroll_action_id IN
2489: (
2490: SELECT org_information3
2491: FROM hr_organization_information
2492: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
2493: AND organization_id = g_gre_id
2494: AND org_information1 = g_year
2495: AND org_information2 = g_quarter

Line 2517: FROM hr_organization_information

2513: AND pai.action_context_id = paa.assignment_action_id
2514: AND paa.payroll_action_id IN
2515: (
2516: SELECT org_information3
2517: FROM hr_organization_information
2518: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
2519: AND organization_id = g_gre_id
2520: AND org_information1 = g_year
2521: AND org_information2 = g_quarter

Line 2849: FROM hr_organization_information hoi

2845: ,hoi.org_information12 ministry_name
2846: ,hoi.org_information13 other_ministry_name
2847: ,hoi.org_information14 pao_reg_code
2848: ,hoi.org_information15 ddo_reg_code
2849: FROM hr_organization_information hoi
2850: ,hr_organization_units hou
2851: WHERE hoi.organization_id = p_gre_id
2852: AND hoi.org_information_context = 'PER_IN_INCOME_TAX_DF'
2853: AND hou.organization_id = hoi.organization_id

Line 2861: FROM hr_organization_information hoi

2857: CURSOR c_reg_org_details(p_reg_org_id NUMBER)
2858: IS
2859: SELECT hoi.org_information3 pan
2860: ,hoi.org_information4 legal_name
2861: FROM hr_organization_information hoi
2862: ,hr_organization_units hou
2863: WHERE hoi.organization_id = p_reg_org_id
2864: AND hoi.org_information_context = 'PER_IN_COMPANY_DF'
2865: AND hou.organization_id = hoi.organization_id

Line 2903: FROM hr_organization_information hoi

2899: IS
2900: SELECT pep.person_id
2901: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) rep_name
2902: ,pep.email_address email_id
2903: FROM hr_organization_information hoi
2904: ,hr_organization_units hou
2905: ,per_people_f pep
2906: WHERE hoi.org_information_context = 'PER_IN_INCOME_TAX_REP_DF'
2907: AND hoi.organization_id = p_gre_id

Line 2930: l_reg_org_id hr_organization_information.org_information4%TYPE;

2926: AND phone_type = 'W1'
2927: AND g_qr_end_date BETWEEN date_from AND NVL(date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
2928:
2929:
2930: l_reg_org_id hr_organization_information.org_information4%TYPE;
2931: l_rep_person_id per_all_people_f.person_id%TYPE;
2932: l_emplr_type hr_organization_information.org_information3%TYPE;
2933: l_emplr_type_24Q hr_organization_information.org_information6%TYPE;
2934: l_procedure VARCHAR2(250);

Line 2932: l_emplr_type hr_organization_information.org_information3%TYPE;

2928:
2929:
2930: l_reg_org_id hr_organization_information.org_information4%TYPE;
2931: l_rep_person_id per_all_people_f.person_id%TYPE;
2932: l_emplr_type hr_organization_information.org_information3%TYPE;
2933: l_emplr_type_24Q hr_organization_information.org_information6%TYPE;
2934: l_procedure VARCHAR2(250);
2935: l_message VARCHAR2(250);
2936: BEGIN

Line 2933: l_emplr_type_24Q hr_organization_information.org_information6%TYPE;

2929:
2930: l_reg_org_id hr_organization_information.org_information4%TYPE;
2931: l_rep_person_id per_all_people_f.person_id%TYPE;
2932: l_emplr_type hr_organization_information.org_information3%TYPE;
2933: l_emplr_type_24Q hr_organization_information.org_information6%TYPE;
2934: l_procedure VARCHAR2(250);
2935: l_message VARCHAR2(250);
2936: BEGIN
2937: g_debug := hr_utility.debug_enabled;

Line 3042: FROM hr_organization_information

3038: AND pai.source_id = p_payroll_action_id
3039: AND pai.action_context_id IN
3040: (
3041: SELECT org_information3
3042: FROM hr_organization_information
3043: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
3044: AND organization_id = g_gre_id
3045: AND org_information1 = g_year
3046: AND org_information2 = g_quarter

Line 3201: l_tan_number hr_organization_information.org_information1%TYPE;

3197: --
3198: l_last_action_context_id NUMBER;
3199: l_dummy NUMBER;
3200: l_flag BOOLEAN;
3201: l_tan_number hr_organization_information.org_information1%TYPE;
3202: l_deductor_type hr_organization_information.org_information3%TYPE;
3203: l_branch_or_division hr_organization_information.org_information7%TYPE;
3204: l_org_location hr_organization_units.location_id%TYPE;
3205: l_pan_number hr_organization_information.org_information3%TYPE;

Line 3202: l_deductor_type hr_organization_information.org_information3%TYPE;

3198: l_last_action_context_id NUMBER;
3199: l_dummy NUMBER;
3200: l_flag BOOLEAN;
3201: l_tan_number hr_organization_information.org_information1%TYPE;
3202: l_deductor_type hr_organization_information.org_information3%TYPE;
3203: l_branch_or_division hr_organization_information.org_information7%TYPE;
3204: l_org_location hr_organization_units.location_id%TYPE;
3205: l_pan_number hr_organization_information.org_information3%TYPE;
3206: l_legal_name hr_organization_information.org_information4%TYPE;

Line 3203: l_branch_or_division hr_organization_information.org_information7%TYPE;

3199: l_dummy NUMBER;
3200: l_flag BOOLEAN;
3201: l_tan_number hr_organization_information.org_information1%TYPE;
3202: l_deductor_type hr_organization_information.org_information3%TYPE;
3203: l_branch_or_division hr_organization_information.org_information7%TYPE;
3204: l_org_location hr_organization_units.location_id%TYPE;
3205: l_pan_number hr_organization_information.org_information3%TYPE;
3206: l_legal_name hr_organization_information.org_information4%TYPE;
3207: l_state hr_organization_information.org_information9%TYPE;

Line 3205: l_pan_number hr_organization_information.org_information3%TYPE;

3201: l_tan_number hr_organization_information.org_information1%TYPE;
3202: l_deductor_type hr_organization_information.org_information3%TYPE;
3203: l_branch_or_division hr_organization_information.org_information7%TYPE;
3204: l_org_location hr_organization_units.location_id%TYPE;
3205: l_pan_number hr_organization_information.org_information3%TYPE;
3206: l_legal_name hr_organization_information.org_information4%TYPE;
3207: l_state hr_organization_information.org_information9%TYPE;
3208: l_pao_code hr_organization_information.org_information10%TYPE;
3209: l_ddo_code hr_organization_information.org_information11%TYPE;

Line 3206: l_legal_name hr_organization_information.org_information4%TYPE;

3202: l_deductor_type hr_organization_information.org_information3%TYPE;
3203: l_branch_or_division hr_organization_information.org_information7%TYPE;
3204: l_org_location hr_organization_units.location_id%TYPE;
3205: l_pan_number hr_organization_information.org_information3%TYPE;
3206: l_legal_name hr_organization_information.org_information4%TYPE;
3207: l_state hr_organization_information.org_information9%TYPE;
3208: l_pao_code hr_organization_information.org_information10%TYPE;
3209: l_ddo_code hr_organization_information.org_information11%TYPE;
3210: l_ministry_name hr_organization_information.org_information12%TYPE;

Line 3207: l_state hr_organization_information.org_information9%TYPE;

3203: l_branch_or_division hr_organization_information.org_information7%TYPE;
3204: l_org_location hr_organization_units.location_id%TYPE;
3205: l_pan_number hr_organization_information.org_information3%TYPE;
3206: l_legal_name hr_organization_information.org_information4%TYPE;
3207: l_state hr_organization_information.org_information9%TYPE;
3208: l_pao_code hr_organization_information.org_information10%TYPE;
3209: l_ddo_code hr_organization_information.org_information11%TYPE;
3210: l_ministry_name hr_organization_information.org_information12%TYPE;
3211: l_other_ministry_name hr_organization_information.org_information13%TYPE;

Line 3208: l_pao_code hr_organization_information.org_information10%TYPE;

3204: l_org_location hr_organization_units.location_id%TYPE;
3205: l_pan_number hr_organization_information.org_information3%TYPE;
3206: l_legal_name hr_organization_information.org_information4%TYPE;
3207: l_state hr_organization_information.org_information9%TYPE;
3208: l_pao_code hr_organization_information.org_information10%TYPE;
3209: l_ddo_code hr_organization_information.org_information11%TYPE;
3210: l_ministry_name hr_organization_information.org_information12%TYPE;
3211: l_other_ministry_name hr_organization_information.org_information13%TYPE;
3212: l_pao_reg_code hr_organization_information.org_information14%TYPE;

Line 3209: l_ddo_code hr_organization_information.org_information11%TYPE;

3205: l_pan_number hr_organization_information.org_information3%TYPE;
3206: l_legal_name hr_organization_information.org_information4%TYPE;
3207: l_state hr_organization_information.org_information9%TYPE;
3208: l_pao_code hr_organization_information.org_information10%TYPE;
3209: l_ddo_code hr_organization_information.org_information11%TYPE;
3210: l_ministry_name hr_organization_information.org_information12%TYPE;
3211: l_other_ministry_name hr_organization_information.org_information13%TYPE;
3212: l_pao_reg_code hr_organization_information.org_information14%TYPE;
3213: l_ddo_reg_code hr_organization_information.org_information15%TYPE;

Line 3210: l_ministry_name hr_organization_information.org_information12%TYPE;

3206: l_legal_name hr_organization_information.org_information4%TYPE;
3207: l_state hr_organization_information.org_information9%TYPE;
3208: l_pao_code hr_organization_information.org_information10%TYPE;
3209: l_ddo_code hr_organization_information.org_information11%TYPE;
3210: l_ministry_name hr_organization_information.org_information12%TYPE;
3211: l_other_ministry_name hr_organization_information.org_information13%TYPE;
3212: l_pao_reg_code hr_organization_information.org_information14%TYPE;
3213: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
3214: l_rep_name per_all_people_f.full_name%TYPE;

Line 3211: l_other_ministry_name hr_organization_information.org_information13%TYPE;

3207: l_state hr_organization_information.org_information9%TYPE;
3208: l_pao_code hr_organization_information.org_information10%TYPE;
3209: l_ddo_code hr_organization_information.org_information11%TYPE;
3210: l_ministry_name hr_organization_information.org_information12%TYPE;
3211: l_other_ministry_name hr_organization_information.org_information13%TYPE;
3212: l_pao_reg_code hr_organization_information.org_information14%TYPE;
3213: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
3214: l_rep_name per_all_people_f.full_name%TYPE;
3215: l_rep_position per_all_positions.name%TYPE;

Line 3212: l_pao_reg_code hr_organization_information.org_information14%TYPE;

3208: l_pao_code hr_organization_information.org_information10%TYPE;
3209: l_ddo_code hr_organization_information.org_information11%TYPE;
3210: l_ministry_name hr_organization_information.org_information12%TYPE;
3211: l_other_ministry_name hr_organization_information.org_information13%TYPE;
3212: l_pao_reg_code hr_organization_information.org_information14%TYPE;
3213: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
3214: l_rep_name per_all_people_f.full_name%TYPE;
3215: l_rep_position per_all_positions.name%TYPE;
3216: l_rep_location hr_organization_units.location_id%TYPE;

Line 3213: l_ddo_reg_code hr_organization_information.org_information15%TYPE;

3209: l_ddo_code hr_organization_information.org_information11%TYPE;
3210: l_ministry_name hr_organization_information.org_information12%TYPE;
3211: l_other_ministry_name hr_organization_information.org_information13%TYPE;
3212: l_pao_reg_code hr_organization_information.org_information14%TYPE;
3213: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
3214: l_rep_name per_all_people_f.full_name%TYPE;
3215: l_rep_position per_all_positions.name%TYPE;
3216: l_rep_location hr_organization_units.location_id%TYPE;
3217: l_rep_email_id per_all_people_f.email_address%TYPE;

Line 3520: FROM hr_organization_information hoi_bank

3516: hoi.org_information8 education_cess,
3517: hoi.org_information10 other,
3518: hoi.org_information9 interest,
3519: (SELECT hoi_bank.org_information4
3520: FROM hr_organization_information hoi_bank
3521: WHERE hoi_bank.organization_id = p_gre_id
3522: AND hoi_bank.org_information_context = 'PER_IN_CHALLAN_BANK'
3523: AND hoi_bank.org_information_id = hoi.org_information5
3524: ) bank_branch_code,

Line 3527: FROM hr_organization_information hoi

3523: AND hoi_bank.org_information_id = hoi.org_information5
3524: ) bank_branch_code,
3525: hoi.org_information11 cheque_dd_num,
3526: hoi.org_information_id org_information_id
3527: FROM hr_organization_information hoi
3528: WHERE hoi.org_information_id IN
3529: (
3530: SELECT hoi.org_information_id
3531: FROM hr_organization_information hoi

Line 3531: FROM hr_organization_information hoi

3527: FROM hr_organization_information hoi
3528: WHERE hoi.org_information_id IN
3529: (
3530: SELECT hoi.org_information_id
3531: FROM hr_organization_information hoi
3532: ,hr_organization_units hou
3533: WHERE hoi.organization_id = p_gre_id
3534: AND hoi.organization_id = hou.organization_id
3535: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 3562: FROM hr_organization_information hoi_bank

3558: hoi.org_information8 education_cess,
3559: hoi.org_information10 other,
3560: hoi.org_information9 interest,
3561: (SELECT hoi_bank.org_information4
3562: FROM hr_organization_information hoi_bank
3563: WHERE hoi_bank.organization_id = p_gre_id
3564: AND hoi_bank.org_information_context = 'PER_IN_CHALLAN_BANK'
3565: AND hoi_bank.org_information_id = hoi.org_information5
3566: ) bank_branch_code,

Line 3569: FROM hr_organization_information hoi

3565: AND hoi_bank.org_information_id = hoi.org_information5
3566: ) bank_branch_code,
3567: hoi.org_information11 cheque_dd_num,
3568: hoi.org_information_id org_information_id
3569: FROM hr_organization_information hoi
3570: WHERE hoi.org_information_id IN
3571: (
3572: SELECT hoi.org_information_id
3573: FROM hr_organization_information hoi

Line 3573: FROM hr_organization_information hoi

3569: FROM hr_organization_information hoi
3570: WHERE hoi.org_information_id IN
3571: (
3572: SELECT hoi.org_information_id
3573: FROM hr_organization_information hoi
3574: ,hr_organization_units hou
3575: WHERE hoi.organization_id = p_gre_id
3576: AND hoi.organization_id = hou.organization_id
3577: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 3611: FROM hr_organization_information

3607: AND action_information_category = p_act_info_category
3608: AND action_context_id IN
3609: (
3610: SELECT org_information3
3611: FROM hr_organization_information
3612: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
3613: AND organization_id = g_gre_id
3614: AND org_information1 = g_year
3615: AND org_information2 = g_quarter

Line 3661: FROM hr_organization_information

3657: AND action_information_category = p_act_info_category
3658: AND action_context_id IN
3659: (
3660: SELECT org_information3
3661: FROM hr_organization_information
3662: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
3663: AND organization_id = g_gre_id
3664: AND org_information1 = g_year
3665: AND org_information2 = g_quarter

Line 3685: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;

3681: ,p_payroll_action_id
3682: ) = p_payroll_action_id
3683: ORDER BY action_information_id DESC;
3684:
3685: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;
3686: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
3687: l_amount hr_organization_information.org_information4%TYPE;
3688: l_surcharge hr_organization_information.org_information7%TYPE;
3689: l_education_cess hr_organization_information.org_information8%TYPE;

Line 3686: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;

3682: ) = p_payroll_action_id
3683: ORDER BY action_information_id DESC;
3684:
3685: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;
3686: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
3687: l_amount hr_organization_information.org_information4%TYPE;
3688: l_surcharge hr_organization_information.org_information7%TYPE;
3689: l_education_cess hr_organization_information.org_information8%TYPE;
3690: l_interest hr_organization_information.org_information9%TYPE;

Line 3687: l_amount hr_organization_information.org_information4%TYPE;

3683: ORDER BY action_information_id DESC;
3684:
3685: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;
3686: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
3687: l_amount hr_organization_information.org_information4%TYPE;
3688: l_surcharge hr_organization_information.org_information7%TYPE;
3689: l_education_cess hr_organization_information.org_information8%TYPE;
3690: l_interest hr_organization_information.org_information9%TYPE;
3691: l_others hr_organization_information.org_information10%TYPE;

Line 3688: l_surcharge hr_organization_information.org_information7%TYPE;

3684:
3685: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;
3686: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
3687: l_amount hr_organization_information.org_information4%TYPE;
3688: l_surcharge hr_organization_information.org_information7%TYPE;
3689: l_education_cess hr_organization_information.org_information8%TYPE;
3690: l_interest hr_organization_information.org_information9%TYPE;
3691: l_others hr_organization_information.org_information10%TYPE;
3692: l_bank_branch_code hr_organization_information.org_information4%TYPE;

Line 3689: l_education_cess hr_organization_information.org_information8%TYPE;

3685: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;
3686: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
3687: l_amount hr_organization_information.org_information4%TYPE;
3688: l_surcharge hr_organization_information.org_information7%TYPE;
3689: l_education_cess hr_organization_information.org_information8%TYPE;
3690: l_interest hr_organization_information.org_information9%TYPE;
3691: l_others hr_organization_information.org_information10%TYPE;
3692: l_bank_branch_code hr_organization_information.org_information4%TYPE;
3693: l_cheque_dd_num hr_organization_information.org_information11%TYPE;

Line 3690: l_interest hr_organization_information.org_information9%TYPE;

3686: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
3687: l_amount hr_organization_information.org_information4%TYPE;
3688: l_surcharge hr_organization_information.org_information7%TYPE;
3689: l_education_cess hr_organization_information.org_information8%TYPE;
3690: l_interest hr_organization_information.org_information9%TYPE;
3691: l_others hr_organization_information.org_information10%TYPE;
3692: l_bank_branch_code hr_organization_information.org_information4%TYPE;
3693: l_cheque_dd_num hr_organization_information.org_information11%TYPE;
3694: l_org_information_id NUMBER;

Line 3691: l_others hr_organization_information.org_information10%TYPE;

3687: l_amount hr_organization_information.org_information4%TYPE;
3688: l_surcharge hr_organization_information.org_information7%TYPE;
3689: l_education_cess hr_organization_information.org_information8%TYPE;
3690: l_interest hr_organization_information.org_information9%TYPE;
3691: l_others hr_organization_information.org_information10%TYPE;
3692: l_bank_branch_code hr_organization_information.org_information4%TYPE;
3693: l_cheque_dd_num hr_organization_information.org_information11%TYPE;
3694: l_org_information_id NUMBER;
3695: l_action_information_id NUMBER;

Line 3692: l_bank_branch_code hr_organization_information.org_information4%TYPE;

3688: l_surcharge hr_organization_information.org_information7%TYPE;
3689: l_education_cess hr_organization_information.org_information8%TYPE;
3690: l_interest hr_organization_information.org_information9%TYPE;
3691: l_others hr_organization_information.org_information10%TYPE;
3692: l_bank_branch_code hr_organization_information.org_information4%TYPE;
3693: l_cheque_dd_num hr_organization_information.org_information11%TYPE;
3694: l_org_information_id NUMBER;
3695: l_action_information_id NUMBER;
3696:

Line 3693: l_cheque_dd_num hr_organization_information.org_information11%TYPE;

3689: l_education_cess hr_organization_information.org_information8%TYPE;
3690: l_interest hr_organization_information.org_information9%TYPE;
3691: l_others hr_organization_information.org_information10%TYPE;
3692: l_bank_branch_code hr_organization_information.org_information4%TYPE;
3693: l_cheque_dd_num hr_organization_information.org_information11%TYPE;
3694: l_org_information_id NUMBER;
3695: l_action_information_id NUMBER;
3696:
3697: l_transfer_voucher_number_1 hr_organization_information.org_information3%TYPE;

Line 3697: l_transfer_voucher_number_1 hr_organization_information.org_information3%TYPE;

3693: l_cheque_dd_num hr_organization_information.org_information11%TYPE;
3694: l_org_information_id NUMBER;
3695: l_action_information_id NUMBER;
3696:
3697: l_transfer_voucher_number_1 hr_organization_information.org_information3%TYPE;
3698: l_transfer_voucher_date_1 hr_organization_information.org_information2%TYPE;
3699: l_amount_1 hr_organization_information.org_information4%TYPE;
3700: l_surcharge_1 hr_organization_information.org_information7%TYPE;
3701: l_education_cess_1 hr_organization_information.org_information8%TYPE;

Line 3698: l_transfer_voucher_date_1 hr_organization_information.org_information2%TYPE;

3694: l_org_information_id NUMBER;
3695: l_action_information_id NUMBER;
3696:
3697: l_transfer_voucher_number_1 hr_organization_information.org_information3%TYPE;
3698: l_transfer_voucher_date_1 hr_organization_information.org_information2%TYPE;
3699: l_amount_1 hr_organization_information.org_information4%TYPE;
3700: l_surcharge_1 hr_organization_information.org_information7%TYPE;
3701: l_education_cess_1 hr_organization_information.org_information8%TYPE;
3702: l_interest_1 hr_organization_information.org_information9%TYPE;

Line 3699: l_amount_1 hr_organization_information.org_information4%TYPE;

3695: l_action_information_id NUMBER;
3696:
3697: l_transfer_voucher_number_1 hr_organization_information.org_information3%TYPE;
3698: l_transfer_voucher_date_1 hr_organization_information.org_information2%TYPE;
3699: l_amount_1 hr_organization_information.org_information4%TYPE;
3700: l_surcharge_1 hr_organization_information.org_information7%TYPE;
3701: l_education_cess_1 hr_organization_information.org_information8%TYPE;
3702: l_interest_1 hr_organization_information.org_information9%TYPE;
3703: l_others_1 hr_organization_information.org_information10%TYPE;

Line 3700: l_surcharge_1 hr_organization_information.org_information7%TYPE;

3696:
3697: l_transfer_voucher_number_1 hr_organization_information.org_information3%TYPE;
3698: l_transfer_voucher_date_1 hr_organization_information.org_information2%TYPE;
3699: l_amount_1 hr_organization_information.org_information4%TYPE;
3700: l_surcharge_1 hr_organization_information.org_information7%TYPE;
3701: l_education_cess_1 hr_organization_information.org_information8%TYPE;
3702: l_interest_1 hr_organization_information.org_information9%TYPE;
3703: l_others_1 hr_organization_information.org_information10%TYPE;
3704: l_bank_branch_code_1 hr_organization_information.org_information4%TYPE;

Line 3701: l_education_cess_1 hr_organization_information.org_information8%TYPE;

3697: l_transfer_voucher_number_1 hr_organization_information.org_information3%TYPE;
3698: l_transfer_voucher_date_1 hr_organization_information.org_information2%TYPE;
3699: l_amount_1 hr_organization_information.org_information4%TYPE;
3700: l_surcharge_1 hr_organization_information.org_information7%TYPE;
3701: l_education_cess_1 hr_organization_information.org_information8%TYPE;
3702: l_interest_1 hr_organization_information.org_information9%TYPE;
3703: l_others_1 hr_organization_information.org_information10%TYPE;
3704: l_bank_branch_code_1 hr_organization_information.org_information4%TYPE;
3705: l_cheque_dd_num_1 hr_organization_information.org_information11%TYPE;

Line 3702: l_interest_1 hr_organization_information.org_information9%TYPE;

3698: l_transfer_voucher_date_1 hr_organization_information.org_information2%TYPE;
3699: l_amount_1 hr_organization_information.org_information4%TYPE;
3700: l_surcharge_1 hr_organization_information.org_information7%TYPE;
3701: l_education_cess_1 hr_organization_information.org_information8%TYPE;
3702: l_interest_1 hr_organization_information.org_information9%TYPE;
3703: l_others_1 hr_organization_information.org_information10%TYPE;
3704: l_bank_branch_code_1 hr_organization_information.org_information4%TYPE;
3705: l_cheque_dd_num_1 hr_organization_information.org_information11%TYPE;
3706: l_org_information_id_1 NUMBER;

Line 3703: l_others_1 hr_organization_information.org_information10%TYPE;

3699: l_amount_1 hr_organization_information.org_information4%TYPE;
3700: l_surcharge_1 hr_organization_information.org_information7%TYPE;
3701: l_education_cess_1 hr_organization_information.org_information8%TYPE;
3702: l_interest_1 hr_organization_information.org_information9%TYPE;
3703: l_others_1 hr_organization_information.org_information10%TYPE;
3704: l_bank_branch_code_1 hr_organization_information.org_information4%TYPE;
3705: l_cheque_dd_num_1 hr_organization_information.org_information11%TYPE;
3706: l_org_information_id_1 NUMBER;
3707: l_dummy_boolean BOOLEAN;

Line 3704: l_bank_branch_code_1 hr_organization_information.org_information4%TYPE;

3700: l_surcharge_1 hr_organization_information.org_information7%TYPE;
3701: l_education_cess_1 hr_organization_information.org_information8%TYPE;
3702: l_interest_1 hr_organization_information.org_information9%TYPE;
3703: l_others_1 hr_organization_information.org_information10%TYPE;
3704: l_bank_branch_code_1 hr_organization_information.org_information4%TYPE;
3705: l_cheque_dd_num_1 hr_organization_information.org_information11%TYPE;
3706: l_org_information_id_1 NUMBER;
3707: l_dummy_boolean BOOLEAN;
3708: l_dummy hr_organization_information.org_information3%TYPE;

Line 3705: l_cheque_dd_num_1 hr_organization_information.org_information11%TYPE;

3701: l_education_cess_1 hr_organization_information.org_information8%TYPE;
3702: l_interest_1 hr_organization_information.org_information9%TYPE;
3703: l_others_1 hr_organization_information.org_information10%TYPE;
3704: l_bank_branch_code_1 hr_organization_information.org_information4%TYPE;
3705: l_cheque_dd_num_1 hr_organization_information.org_information11%TYPE;
3706: l_org_information_id_1 NUMBER;
3707: l_dummy_boolean BOOLEAN;
3708: l_dummy hr_organization_information.org_information3%TYPE;
3709: l_procedure VARCHAR2(250);

Line 3708: l_dummy hr_organization_information.org_information3%TYPE;

3704: l_bank_branch_code_1 hr_organization_information.org_information4%TYPE;
3705: l_cheque_dd_num_1 hr_organization_information.org_information11%TYPE;
3706: l_org_information_id_1 NUMBER;
3707: l_dummy_boolean BOOLEAN;
3708: l_dummy hr_organization_information.org_information3%TYPE;
3709: l_procedure VARCHAR2(250);
3710: l_message VARCHAR2(250);
3711: BEGIN
3712: g_debug := hr_utility.debug_enabled;

Line 4612: FROM hr_organization_information

4608: AND paa.payroll_action_id = p_24qa_pay_act_id
4609: AND paa_master.assignment_action_id = pai.action_context_id
4610: AND paa_master.payroll_action_id IN(
4611: SELECT org_information3
4612: FROM hr_organization_information
4613: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
4614: AND organization_id = g_gre_id
4615: AND org_information1 = g_year
4616: AND org_information2 = g_quarter

Line 4661: FROM hr_organization_information

4657: AND paa.payroll_action_id = p_24qa_pay_act_id
4658: AND paa_master.assignment_action_id = pai.action_context_id
4659: AND paa_master.payroll_action_id IN(
4660: SELECT org_information3
4661: FROM hr_organization_information
4662: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
4663: AND organization_id = g_gre_id
4664: AND org_information1 = g_year
4665: AND org_information2 = g_quarter

Line 5245: FROM hr_organization_information

5241: AND pai.action_context_id = paa.assignment_action_id
5242: AND paa.payroll_action_id = p_24qa_pay_act_id
5243: AND paa.payroll_action_id IN(
5244: SELECT org_information3
5245: FROM hr_organization_information
5246: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
5247: AND organization_id = g_gre_id
5248: AND org_information1 = g_year
5249: AND org_information2 = g_quarter

Line 5274: FROM hr_organization_information

5270: AND paa.payroll_action_id = p_24qa_pay_act_id
5271: AND paa_master.assignment_action_id = pai.action_context_id
5272: AND paa_master.payroll_action_id IN(
5273: SELECT org_information3
5274: FROM hr_organization_information
5275: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
5276: AND organization_id = g_gre_id
5277: AND org_information1 = g_year
5278: AND org_information2 = g_quarter

Line 5295: FROM hr_organization_information

5291: AND pai.action_context_id = paa.assignment_action_id
5292: AND paa.payroll_action_id = p_24qa_pay_act_id
5293: AND paa.payroll_action_id IN(
5294: SELECT org_information3
5295: FROM hr_organization_information
5296: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
5297: AND organization_id = g_gre_id
5298: AND org_information1 = g_year
5299: AND org_information2 = g_quarter

Line 5321: FROM hr_organization_information

5317: AND paa.payroll_action_id = p_24qa_pay_act_id
5318: AND paa_master.assignment_action_id = pai.action_context_id
5319: AND paa_master.payroll_action_id IN(
5320: SELECT org_information3
5321: FROM hr_organization_information
5322: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
5323: AND organization_id = g_gre_id
5324: AND org_information1 = g_year
5325: AND org_information2 = g_quarter

Line 5425: FROM hr_organization_information

5421: AND paa.payroll_action_id = p_24qa_pay_act_id
5422: AND paa_master.assignment_action_id = pai.action_context_id
5423: AND paa_master.payroll_action_id IN(
5424: SELECT org_information3
5425: FROM hr_organization_information
5426: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
5427: AND organization_id = g_gre_id
5428: AND org_information1 = g_year
5429: AND org_information2 = g_quarter

Line 6669: FROM hr_organization_information

6665: AND paa.payroll_action_id = p_24qa_pay_act_id
6666: AND paa_master.assignment_action_id = pai.action_context_id
6667: AND paa_master.payroll_action_id IN(
6668: SELECT org_information3
6669: FROM hr_organization_information
6670: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
6671: AND organization_id = g_gre_id
6672: AND org_information1 = g_year
6673: AND org_information2 = g_quarter

Line 6690: FROM hr_organization_information

6686: AND pai.action_context_id = paa.assignment_action_id
6687: AND paa.payroll_action_id = p_24qa_pay_act_id
6688: AND paa.payroll_action_id IN(
6689: SELECT org_information3
6690: FROM hr_organization_information
6691: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
6692: AND organization_id = g_gre_id
6693: AND org_information1 = g_year
6694: AND org_information2 = g_quarter

Line 7197: FROM hr_organization_information

7193: AND action_information15 = p_24qa_pay_act_id
7194: AND NVL(action_information4,'BOOK')||' - '||action_information1||' - '||to_char(fnd_date.canonical_to_date(action_information5),'DD-Mon-RRRR') = p_transfer_voucher_number
7195: AND action_context_id IN(
7196: SELECT org_information3
7197: FROM hr_organization_information
7198: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
7199: AND organization_id = g_gre_id
7200: AND org_information1 = g_year
7201: AND org_information2 = g_quarter

Line 7234: FROM hr_organization_information hoi_bank

7230: hoi.org_information8 education_cess,
7231: hoi.org_information10 other,
7232: hoi.org_information9 interest,
7233: (SELECT hoi_bank.org_information4
7234: FROM hr_organization_information hoi_bank
7235: WHERE hoi_bank.organization_id = g_gre_id
7236: AND hoi_bank.org_information_context = 'PER_IN_CHALLAN_BANK'
7237: AND hoi_bank.org_information_id = hoi.org_information5
7238: ) bank_branch_code,

Line 7242: FROM hr_organization_information hoi

7238: ) bank_branch_code,
7239: hoi.org_information11 cheque_dd_num,
7240: hoi.org_information12 book_entry,
7241: hoi.org_information_id org_information_id
7242: FROM hr_organization_information hoi
7243: WHERE hoi.org_information_id IN
7244: (
7245: SELECT hoi.org_information_id
7246: FROM hr_organization_information hoi

Line 7246: FROM hr_organization_information hoi

7242: FROM hr_organization_information hoi
7243: WHERE hoi.org_information_id IN
7244: (
7245: SELECT hoi.org_information_id
7246: FROM hr_organization_information hoi
7247: ,hr_organization_units hou
7248: WHERE hoi.organization_id = g_gre_id
7249: AND hoi.organization_id = hou.organization_id
7250: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 7428: FROM hr_organization_information hoi_bank

7424: hoi.org_information8 education_cess,
7425: hoi.org_information10 other,
7426: hoi.org_information9 interest,
7427: (SELECT hoi_bank.org_information4
7428: FROM hr_organization_information hoi_bank
7429: WHERE hoi_bank.organization_id = g_gre_id
7430: AND hoi_bank.org_information_context = 'PER_IN_CHALLAN_BANK'
7431: AND hoi_bank.org_information_id = hoi.org_information5
7432: ) bank_branch_code,

Line 7436: FROM hr_organization_information hoi

7432: ) bank_branch_code,
7433: hoi.org_information11 cheque_dd_num,
7434: hoi.org_information12 book_entry,
7435: hoi.org_information_id org_information_id
7436: FROM hr_organization_information hoi
7437: WHERE hoi.org_information_id IN
7438: (
7439: SELECT hoi.org_information_id
7440: FROM hr_organization_information hoi

Line 7440: FROM hr_organization_information hoi

7436: FROM hr_organization_information hoi
7437: WHERE hoi.org_information_id IN
7438: (
7439: SELECT hoi.org_information_id
7440: FROM hr_organization_information hoi
7441: ,hr_organization_units hou
7442: WHERE hoi.organization_id = g_gre_id
7443: AND hoi.organization_id = hou.organization_id
7444: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 7455: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;

7451: OR
7452: (hoi.org_information_id = p_org_information_id)
7453: );
7454:
7455: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;
7456: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
7457: l_amount hr_organization_information.org_information4%TYPE;
7458: l_surcharge hr_organization_information.org_information7%TYPE;
7459: l_education_cess hr_organization_information.org_information8%TYPE;

Line 7456: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;

7452: (hoi.org_information_id = p_org_information_id)
7453: );
7454:
7455: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;
7456: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
7457: l_amount hr_organization_information.org_information4%TYPE;
7458: l_surcharge hr_organization_information.org_information7%TYPE;
7459: l_education_cess hr_organization_information.org_information8%TYPE;
7460: l_others hr_organization_information.org_information10%TYPE;

Line 7457: l_amount hr_organization_information.org_information4%TYPE;

7453: );
7454:
7455: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;
7456: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
7457: l_amount hr_organization_information.org_information4%TYPE;
7458: l_surcharge hr_organization_information.org_information7%TYPE;
7459: l_education_cess hr_organization_information.org_information8%TYPE;
7460: l_others hr_organization_information.org_information10%TYPE;
7461: l_interest hr_organization_information.org_information9%TYPE;

Line 7458: l_surcharge hr_organization_information.org_information7%TYPE;

7454:
7455: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;
7456: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
7457: l_amount hr_organization_information.org_information4%TYPE;
7458: l_surcharge hr_organization_information.org_information7%TYPE;
7459: l_education_cess hr_organization_information.org_information8%TYPE;
7460: l_others hr_organization_information.org_information10%TYPE;
7461: l_interest hr_organization_information.org_information9%TYPE;
7462: l_bank_branch_code hr_organization_information.org_information4%TYPE;

Line 7459: l_education_cess hr_organization_information.org_information8%TYPE;

7455: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;
7456: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
7457: l_amount hr_organization_information.org_information4%TYPE;
7458: l_surcharge hr_organization_information.org_information7%TYPE;
7459: l_education_cess hr_organization_information.org_information8%TYPE;
7460: l_others hr_organization_information.org_information10%TYPE;
7461: l_interest hr_organization_information.org_information9%TYPE;
7462: l_bank_branch_code hr_organization_information.org_information4%TYPE;
7463: l_cheque_dd_num hr_organization_information.org_information11%TYPE;

Line 7460: l_others hr_organization_information.org_information10%TYPE;

7456: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
7457: l_amount hr_organization_information.org_information4%TYPE;
7458: l_surcharge hr_organization_information.org_information7%TYPE;
7459: l_education_cess hr_organization_information.org_information8%TYPE;
7460: l_others hr_organization_information.org_information10%TYPE;
7461: l_interest hr_organization_information.org_information9%TYPE;
7462: l_bank_branch_code hr_organization_information.org_information4%TYPE;
7463: l_cheque_dd_num hr_organization_information.org_information11%TYPE;
7464: l_book_entry hr_organization_information.org_information12%TYPE;

Line 7461: l_interest hr_organization_information.org_information9%TYPE;

7457: l_amount hr_organization_information.org_information4%TYPE;
7458: l_surcharge hr_organization_information.org_information7%TYPE;
7459: l_education_cess hr_organization_information.org_information8%TYPE;
7460: l_others hr_organization_information.org_information10%TYPE;
7461: l_interest hr_organization_information.org_information9%TYPE;
7462: l_bank_branch_code hr_organization_information.org_information4%TYPE;
7463: l_cheque_dd_num hr_organization_information.org_information11%TYPE;
7464: l_book_entry hr_organization_information.org_information12%TYPE;
7465: l_org_information_id NUMBER;

Line 7462: l_bank_branch_code hr_organization_information.org_information4%TYPE;

7458: l_surcharge hr_organization_information.org_information7%TYPE;
7459: l_education_cess hr_organization_information.org_information8%TYPE;
7460: l_others hr_organization_information.org_information10%TYPE;
7461: l_interest hr_organization_information.org_information9%TYPE;
7462: l_bank_branch_code hr_organization_information.org_information4%TYPE;
7463: l_cheque_dd_num hr_organization_information.org_information11%TYPE;
7464: l_book_entry hr_organization_information.org_information12%TYPE;
7465: l_org_information_id NUMBER;
7466: l_previous_total_amount NUMBER;

Line 7463: l_cheque_dd_num hr_organization_information.org_information11%TYPE;

7459: l_education_cess hr_organization_information.org_information8%TYPE;
7460: l_others hr_organization_information.org_information10%TYPE;
7461: l_interest hr_organization_information.org_information9%TYPE;
7462: l_bank_branch_code hr_organization_information.org_information4%TYPE;
7463: l_cheque_dd_num hr_organization_information.org_information11%TYPE;
7464: l_book_entry hr_organization_information.org_information12%TYPE;
7465: l_org_information_id NUMBER;
7466: l_previous_total_amount NUMBER;
7467: l_challan_record_number NUMBER;

Line 7464: l_book_entry hr_organization_information.org_information12%TYPE;

7460: l_others hr_organization_information.org_information10%TYPE;
7461: l_interest hr_organization_information.org_information9%TYPE;
7462: l_bank_branch_code hr_organization_information.org_information4%TYPE;
7463: l_cheque_dd_num hr_organization_information.org_information11%TYPE;
7464: l_book_entry hr_organization_information.org_information12%TYPE;
7465: l_org_information_id NUMBER;
7466: l_previous_total_amount NUMBER;
7467: l_challan_record_number NUMBER;
7468: l_action_info_id NUMBER;

Line 7490: FROM hr_organization_information

7486: AND action_information2 = g_year||g_quarter
7487: AND action_context_id = p_24qa_pay_act_id
7488: AND action_context_id IN(
7489: SELECT org_information3
7490: FROM hr_organization_information
7491: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
7492: AND organization_id = g_gre_id
7493: AND org_information1 = g_year
7494: AND org_information2 = g_quarter

Line 7509: FROM hr_organization_information

7505: AND action_information2 = g_year||g_quarter
7506: AND action_information15 = p_24qa_pay_act_id
7507: AND action_context_id IN(
7508: SELECT org_information3
7509: FROM hr_organization_information
7510: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
7511: AND organization_id = g_gre_id
7512: AND org_information1 = g_year
7513: AND org_information2 = g_quarter

Line 7618: FROM hr_organization_information

7614: source_id = g_challan_data_upd(i).org_information_id
7615: )
7616: AND p_24qa_pay_act_id IN(
7617: SELECT org_information3
7618: FROM hr_organization_information
7619: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
7620: AND organization_id = g_gre_id
7621: AND org_information1 = g_year
7622: AND org_information2 = g_quarter

Line 7646: FROM hr_organization_information

7642: source_id = g_challan_data_upd(i).org_information_id
7643: )
7644: AND action_information15 IN(
7645: SELECT org_information3
7646: FROM hr_organization_information
7647: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
7648: AND organization_id = g_gre_id
7649: AND org_information1 = g_year
7650: AND org_information2 = g_quarter

Line 7749: FROM hr_organization_information

7745: IS
7746: CURSOR c_get_act_ctxt_id
7747: IS
7748: SELECT org_information3
7749: FROM hr_organization_information
7750: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
7751: AND organization_id = g_gre_id
7752: AND org_information1 = g_year
7753: AND org_information4 = g_cancel_ref_number;

Line 7906: l_tan_number hr_organization_information.org_information1%TYPE;

7902: AND action_information2 = p_tan_number
7903: AND action_information3 = g_year||g_quarter
7904: ORDER BY action_context_id DESC;
7905:
7906: l_tan_number hr_organization_information.org_information1%TYPE;
7907: l_deductor_type hr_organization_information.org_information3%TYPE;
7908: l_branch_or_division hr_organization_information.org_information7%TYPE;
7909: l_org_location hr_organization_units.location_id%TYPE;
7910: l_pan_number hr_organization_information.org_information3%TYPE;

Line 7907: l_deductor_type hr_organization_information.org_information3%TYPE;

7903: AND action_information3 = g_year||g_quarter
7904: ORDER BY action_context_id DESC;
7905:
7906: l_tan_number hr_organization_information.org_information1%TYPE;
7907: l_deductor_type hr_organization_information.org_information3%TYPE;
7908: l_branch_or_division hr_organization_information.org_information7%TYPE;
7909: l_org_location hr_organization_units.location_id%TYPE;
7910: l_pan_number hr_organization_information.org_information3%TYPE;
7911: l_legal_name hr_organization_information.org_information4%TYPE;

Line 7908: l_branch_or_division hr_organization_information.org_information7%TYPE;

7904: ORDER BY action_context_id DESC;
7905:
7906: l_tan_number hr_organization_information.org_information1%TYPE;
7907: l_deductor_type hr_organization_information.org_information3%TYPE;
7908: l_branch_or_division hr_organization_information.org_information7%TYPE;
7909: l_org_location hr_organization_units.location_id%TYPE;
7910: l_pan_number hr_organization_information.org_information3%TYPE;
7911: l_legal_name hr_organization_information.org_information4%TYPE;
7912: l_state hr_organization_information.org_information9%TYPE;

Line 7910: l_pan_number hr_organization_information.org_information3%TYPE;

7906: l_tan_number hr_organization_information.org_information1%TYPE;
7907: l_deductor_type hr_organization_information.org_information3%TYPE;
7908: l_branch_or_division hr_organization_information.org_information7%TYPE;
7909: l_org_location hr_organization_units.location_id%TYPE;
7910: l_pan_number hr_organization_information.org_information3%TYPE;
7911: l_legal_name hr_organization_information.org_information4%TYPE;
7912: l_state hr_organization_information.org_information9%TYPE;
7913: l_pao_code hr_organization_information.org_information10%TYPE;
7914: l_ddo_code hr_organization_information.org_information11%TYPE;

Line 7911: l_legal_name hr_organization_information.org_information4%TYPE;

7907: l_deductor_type hr_organization_information.org_information3%TYPE;
7908: l_branch_or_division hr_organization_information.org_information7%TYPE;
7909: l_org_location hr_organization_units.location_id%TYPE;
7910: l_pan_number hr_organization_information.org_information3%TYPE;
7911: l_legal_name hr_organization_information.org_information4%TYPE;
7912: l_state hr_organization_information.org_information9%TYPE;
7913: l_pao_code hr_organization_information.org_information10%TYPE;
7914: l_ddo_code hr_organization_information.org_information11%TYPE;
7915: l_ministry_name hr_organization_information.org_information12%TYPE;

Line 7912: l_state hr_organization_information.org_information9%TYPE;

7908: l_branch_or_division hr_organization_information.org_information7%TYPE;
7909: l_org_location hr_organization_units.location_id%TYPE;
7910: l_pan_number hr_organization_information.org_information3%TYPE;
7911: l_legal_name hr_organization_information.org_information4%TYPE;
7912: l_state hr_organization_information.org_information9%TYPE;
7913: l_pao_code hr_organization_information.org_information10%TYPE;
7914: l_ddo_code hr_organization_information.org_information11%TYPE;
7915: l_ministry_name hr_organization_information.org_information12%TYPE;
7916: l_other_ministry_name hr_organization_information.org_information13%TYPE;

Line 7913: l_pao_code hr_organization_information.org_information10%TYPE;

7909: l_org_location hr_organization_units.location_id%TYPE;
7910: l_pan_number hr_organization_information.org_information3%TYPE;
7911: l_legal_name hr_organization_information.org_information4%TYPE;
7912: l_state hr_organization_information.org_information9%TYPE;
7913: l_pao_code hr_organization_information.org_information10%TYPE;
7914: l_ddo_code hr_organization_information.org_information11%TYPE;
7915: l_ministry_name hr_organization_information.org_information12%TYPE;
7916: l_other_ministry_name hr_organization_information.org_information13%TYPE;
7917: l_pao_reg_code hr_organization_information.org_information14%TYPE;

Line 7914: l_ddo_code hr_organization_information.org_information11%TYPE;

7910: l_pan_number hr_organization_information.org_information3%TYPE;
7911: l_legal_name hr_organization_information.org_information4%TYPE;
7912: l_state hr_organization_information.org_information9%TYPE;
7913: l_pao_code hr_organization_information.org_information10%TYPE;
7914: l_ddo_code hr_organization_information.org_information11%TYPE;
7915: l_ministry_name hr_organization_information.org_information12%TYPE;
7916: l_other_ministry_name hr_organization_information.org_information13%TYPE;
7917: l_pao_reg_code hr_organization_information.org_information14%TYPE;
7918: l_ddo_reg_code hr_organization_information.org_information15%TYPE;

Line 7915: l_ministry_name hr_organization_information.org_information12%TYPE;

7911: l_legal_name hr_organization_information.org_information4%TYPE;
7912: l_state hr_organization_information.org_information9%TYPE;
7913: l_pao_code hr_organization_information.org_information10%TYPE;
7914: l_ddo_code hr_organization_information.org_information11%TYPE;
7915: l_ministry_name hr_organization_information.org_information12%TYPE;
7916: l_other_ministry_name hr_organization_information.org_information13%TYPE;
7917: l_pao_reg_code hr_organization_information.org_information14%TYPE;
7918: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
7919: l_rep_name per_all_people_f.full_name%TYPE;

Line 7916: l_other_ministry_name hr_organization_information.org_information13%TYPE;

7912: l_state hr_organization_information.org_information9%TYPE;
7913: l_pao_code hr_organization_information.org_information10%TYPE;
7914: l_ddo_code hr_organization_information.org_information11%TYPE;
7915: l_ministry_name hr_organization_information.org_information12%TYPE;
7916: l_other_ministry_name hr_organization_information.org_information13%TYPE;
7917: l_pao_reg_code hr_organization_information.org_information14%TYPE;
7918: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
7919: l_rep_name per_all_people_f.full_name%TYPE;
7920: l_rep_position per_all_positions.name%TYPE;

Line 7917: l_pao_reg_code hr_organization_information.org_information14%TYPE;

7913: l_pao_code hr_organization_information.org_information10%TYPE;
7914: l_ddo_code hr_organization_information.org_information11%TYPE;
7915: l_ministry_name hr_organization_information.org_information12%TYPE;
7916: l_other_ministry_name hr_organization_information.org_information13%TYPE;
7917: l_pao_reg_code hr_organization_information.org_information14%TYPE;
7918: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
7919: l_rep_name per_all_people_f.full_name%TYPE;
7920: l_rep_position per_all_positions.name%TYPE;
7921: l_rep_location hr_organization_units.location_id%TYPE;

Line 7918: l_ddo_reg_code hr_organization_information.org_information15%TYPE;

7914: l_ddo_code hr_organization_information.org_information11%TYPE;
7915: l_ministry_name hr_organization_information.org_information12%TYPE;
7916: l_other_ministry_name hr_organization_information.org_information13%TYPE;
7917: l_pao_reg_code hr_organization_information.org_information14%TYPE;
7918: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
7919: l_rep_name per_all_people_f.full_name%TYPE;
7920: l_rep_position per_all_positions.name%TYPE;
7921: l_rep_location hr_organization_units.location_id%TYPE;
7922: l_rep_email_id per_all_people_f.email_address%TYPE;

Line 7930: l_previous_org_legal_name hr_organization_information.org_information4%TYPE;

7926: l_action_info_id NUMBER;
7927: l_ovn NUMBER;
7928: l_new_nil_challan VARCHAR2(1);
7929: l_old_nil_challan VARCHAR2(1);
7930: l_previous_org_legal_name hr_organization_information.org_information4%TYPE;
7931: l_previous_deductor_type hr_organization_information.org_information3%TYPE;
7932: l_previous_emplr_type hr_organization_information.org_information3%TYPE;
7933: l_previous_emplr_type_24Q hr_organization_information.org_information6%TYPE;
7934: l_batch_upd_indicator NUMBER;

Line 7931: l_previous_deductor_type hr_organization_information.org_information3%TYPE;

7927: l_ovn NUMBER;
7928: l_new_nil_challan VARCHAR2(1);
7929: l_old_nil_challan VARCHAR2(1);
7930: l_previous_org_legal_name hr_organization_information.org_information4%TYPE;
7931: l_previous_deductor_type hr_organization_information.org_information3%TYPE;
7932: l_previous_emplr_type hr_organization_information.org_information3%TYPE;
7933: l_previous_emplr_type_24Q hr_organization_information.org_information6%TYPE;
7934: l_batch_upd_indicator NUMBER;
7935: i NUMBER;

Line 7932: l_previous_emplr_type hr_organization_information.org_information3%TYPE;

7928: l_new_nil_challan VARCHAR2(1);
7929: l_old_nil_challan VARCHAR2(1);
7930: l_previous_org_legal_name hr_organization_information.org_information4%TYPE;
7931: l_previous_deductor_type hr_organization_information.org_information3%TYPE;
7932: l_previous_emplr_type hr_organization_information.org_information3%TYPE;
7933: l_previous_emplr_type_24Q hr_organization_information.org_information6%TYPE;
7934: l_batch_upd_indicator NUMBER;
7935: i NUMBER;
7936: l_dummy NUMBER;

Line 7933: l_previous_emplr_type_24Q hr_organization_information.org_information6%TYPE;

7929: l_old_nil_challan VARCHAR2(1);
7930: l_previous_org_legal_name hr_organization_information.org_information4%TYPE;
7931: l_previous_deductor_type hr_organization_information.org_information3%TYPE;
7932: l_previous_emplr_type hr_organization_information.org_information3%TYPE;
7933: l_previous_emplr_type_24Q hr_organization_information.org_information6%TYPE;
7934: l_batch_upd_indicator NUMBER;
7935: i NUMBER;
7936: l_dummy NUMBER;
7937: l_flag NUMBER := -1;

Line 8244: FROM hr_organization_information

8240:
8241: CURSOR c_select_prev_24qc
8242: IS
8243: SELECT MAX(org_information3)
8244: FROM hr_organization_information
8245: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
8246: AND organization_id = g_gre_id
8247: AND org_information1 = g_year
8248: AND org_information2 = g_quarter

Line 8438: FROM hr_organization_information

8434: AND pai.action_information1 = p_challan_number
8435: AND pai.action_context_id IN
8436: (
8437: SELECT org_information3
8438: FROM hr_organization_information
8439: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
8440: AND organization_id = g_gre_id
8441: AND org_information1 = g_year
8442: AND org_information2 = g_quarter

Line 8463: l_tan_number hr_organization_information.org_information1%TYPE;

8459: AND action_information3 = g_year||g_quarter
8460: ORDER BY action_context_id DESC;
8461:
8462: l_challan_deductee_no VARCHAR2(250);
8463: l_tan_number hr_organization_information.org_information1%TYPE;
8464: l_deductor_type hr_organization_information.org_information3%TYPE;
8465: l_emplr_type hr_organization_information.org_information3%TYPE;
8466: l_emplr_type_24Q hr_organization_information.org_information6%TYPE;
8467: l_branch_or_division hr_organization_information.org_information7%TYPE;

Line 8464: l_deductor_type hr_organization_information.org_information3%TYPE;

8460: ORDER BY action_context_id DESC;
8461:
8462: l_challan_deductee_no VARCHAR2(250);
8463: l_tan_number hr_organization_information.org_information1%TYPE;
8464: l_deductor_type hr_organization_information.org_information3%TYPE;
8465: l_emplr_type hr_organization_information.org_information3%TYPE;
8466: l_emplr_type_24Q hr_organization_information.org_information6%TYPE;
8467: l_branch_or_division hr_organization_information.org_information7%TYPE;
8468: l_org_location hr_organization_units.location_id%TYPE;

Line 8465: l_emplr_type hr_organization_information.org_information3%TYPE;

8461:
8462: l_challan_deductee_no VARCHAR2(250);
8463: l_tan_number hr_organization_information.org_information1%TYPE;
8464: l_deductor_type hr_organization_information.org_information3%TYPE;
8465: l_emplr_type hr_organization_information.org_information3%TYPE;
8466: l_emplr_type_24Q hr_organization_information.org_information6%TYPE;
8467: l_branch_or_division hr_organization_information.org_information7%TYPE;
8468: l_org_location hr_organization_units.location_id%TYPE;
8469: l_pan_number hr_organization_information.org_information3%TYPE;

Line 8466: l_emplr_type_24Q hr_organization_information.org_information6%TYPE;

8462: l_challan_deductee_no VARCHAR2(250);
8463: l_tan_number hr_organization_information.org_information1%TYPE;
8464: l_deductor_type hr_organization_information.org_information3%TYPE;
8465: l_emplr_type hr_organization_information.org_information3%TYPE;
8466: l_emplr_type_24Q hr_organization_information.org_information6%TYPE;
8467: l_branch_or_division hr_organization_information.org_information7%TYPE;
8468: l_org_location hr_organization_units.location_id%TYPE;
8469: l_pan_number hr_organization_information.org_information3%TYPE;
8470: l_legal_name hr_organization_information.org_information4%TYPE;

Line 8467: l_branch_or_division hr_organization_information.org_information7%TYPE;

8463: l_tan_number hr_organization_information.org_information1%TYPE;
8464: l_deductor_type hr_organization_information.org_information3%TYPE;
8465: l_emplr_type hr_organization_information.org_information3%TYPE;
8466: l_emplr_type_24Q hr_organization_information.org_information6%TYPE;
8467: l_branch_or_division hr_organization_information.org_information7%TYPE;
8468: l_org_location hr_organization_units.location_id%TYPE;
8469: l_pan_number hr_organization_information.org_information3%TYPE;
8470: l_legal_name hr_organization_information.org_information4%TYPE;
8471: l_state hr_organization_information.org_information9%TYPE;

Line 8469: l_pan_number hr_organization_information.org_information3%TYPE;

8465: l_emplr_type hr_organization_information.org_information3%TYPE;
8466: l_emplr_type_24Q hr_organization_information.org_information6%TYPE;
8467: l_branch_or_division hr_organization_information.org_information7%TYPE;
8468: l_org_location hr_organization_units.location_id%TYPE;
8469: l_pan_number hr_organization_information.org_information3%TYPE;
8470: l_legal_name hr_organization_information.org_information4%TYPE;
8471: l_state hr_organization_information.org_information9%TYPE;
8472: l_pao_code hr_organization_information.org_information10%TYPE;
8473: l_ddo_code hr_organization_information.org_information11%TYPE;

Line 8470: l_legal_name hr_organization_information.org_information4%TYPE;

8466: l_emplr_type_24Q hr_organization_information.org_information6%TYPE;
8467: l_branch_or_division hr_organization_information.org_information7%TYPE;
8468: l_org_location hr_organization_units.location_id%TYPE;
8469: l_pan_number hr_organization_information.org_information3%TYPE;
8470: l_legal_name hr_organization_information.org_information4%TYPE;
8471: l_state hr_organization_information.org_information9%TYPE;
8472: l_pao_code hr_organization_information.org_information10%TYPE;
8473: l_ddo_code hr_organization_information.org_information11%TYPE;
8474: l_ministry_name hr_organization_information.org_information12%TYPE;

Line 8471: l_state hr_organization_information.org_information9%TYPE;

8467: l_branch_or_division hr_organization_information.org_information7%TYPE;
8468: l_org_location hr_organization_units.location_id%TYPE;
8469: l_pan_number hr_organization_information.org_information3%TYPE;
8470: l_legal_name hr_organization_information.org_information4%TYPE;
8471: l_state hr_organization_information.org_information9%TYPE;
8472: l_pao_code hr_organization_information.org_information10%TYPE;
8473: l_ddo_code hr_organization_information.org_information11%TYPE;
8474: l_ministry_name hr_organization_information.org_information12%TYPE;
8475: l_other_ministry_name hr_organization_information.org_information13%TYPE;

Line 8472: l_pao_code hr_organization_information.org_information10%TYPE;

8468: l_org_location hr_organization_units.location_id%TYPE;
8469: l_pan_number hr_organization_information.org_information3%TYPE;
8470: l_legal_name hr_organization_information.org_information4%TYPE;
8471: l_state hr_organization_information.org_information9%TYPE;
8472: l_pao_code hr_organization_information.org_information10%TYPE;
8473: l_ddo_code hr_organization_information.org_information11%TYPE;
8474: l_ministry_name hr_organization_information.org_information12%TYPE;
8475: l_other_ministry_name hr_organization_information.org_information13%TYPE;
8476: l_pao_reg_code hr_organization_information.org_information14%TYPE;

Line 8473: l_ddo_code hr_organization_information.org_information11%TYPE;

8469: l_pan_number hr_organization_information.org_information3%TYPE;
8470: l_legal_name hr_organization_information.org_information4%TYPE;
8471: l_state hr_organization_information.org_information9%TYPE;
8472: l_pao_code hr_organization_information.org_information10%TYPE;
8473: l_ddo_code hr_organization_information.org_information11%TYPE;
8474: l_ministry_name hr_organization_information.org_information12%TYPE;
8475: l_other_ministry_name hr_organization_information.org_information13%TYPE;
8476: l_pao_reg_code hr_organization_information.org_information14%TYPE;
8477: l_ddo_reg_code hr_organization_information.org_information15%TYPE;

Line 8474: l_ministry_name hr_organization_information.org_information12%TYPE;

8470: l_legal_name hr_organization_information.org_information4%TYPE;
8471: l_state hr_organization_information.org_information9%TYPE;
8472: l_pao_code hr_organization_information.org_information10%TYPE;
8473: l_ddo_code hr_organization_information.org_information11%TYPE;
8474: l_ministry_name hr_organization_information.org_information12%TYPE;
8475: l_other_ministry_name hr_organization_information.org_information13%TYPE;
8476: l_pao_reg_code hr_organization_information.org_information14%TYPE;
8477: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
8478: l_rep_name per_all_people_f.full_name%TYPE;

Line 8475: l_other_ministry_name hr_organization_information.org_information13%TYPE;

8471: l_state hr_organization_information.org_information9%TYPE;
8472: l_pao_code hr_organization_information.org_information10%TYPE;
8473: l_ddo_code hr_organization_information.org_information11%TYPE;
8474: l_ministry_name hr_organization_information.org_information12%TYPE;
8475: l_other_ministry_name hr_organization_information.org_information13%TYPE;
8476: l_pao_reg_code hr_organization_information.org_information14%TYPE;
8477: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
8478: l_rep_name per_all_people_f.full_name%TYPE;
8479: l_rep_position per_all_positions.name%TYPE;

Line 8476: l_pao_reg_code hr_organization_information.org_information14%TYPE;

8472: l_pao_code hr_organization_information.org_information10%TYPE;
8473: l_ddo_code hr_organization_information.org_information11%TYPE;
8474: l_ministry_name hr_organization_information.org_information12%TYPE;
8475: l_other_ministry_name hr_organization_information.org_information13%TYPE;
8476: l_pao_reg_code hr_organization_information.org_information14%TYPE;
8477: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
8478: l_rep_name per_all_people_f.full_name%TYPE;
8479: l_rep_position per_all_positions.name%TYPE;
8480: l_rep_location hr_organization_units.location_id%TYPE;

Line 8477: l_ddo_reg_code hr_organization_information.org_information15%TYPE;

8473: l_ddo_code hr_organization_information.org_information11%TYPE;
8474: l_ministry_name hr_organization_information.org_information12%TYPE;
8475: l_other_ministry_name hr_organization_information.org_information13%TYPE;
8476: l_pao_reg_code hr_organization_information.org_information14%TYPE;
8477: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
8478: l_rep_name per_all_people_f.full_name%TYPE;
8479: l_rep_position per_all_positions.name%TYPE;
8480: l_rep_location hr_organization_units.location_id%TYPE;
8481: l_rep_email_id per_all_people_f.email_address%TYPE;

Line 8687: FROM hr_organization_information

8683: CURSOR c_pay_act_id_last_24Q
8684: IS
8685: SELECT org_information3 -- payroll action id of this quarter Form 24Q A/C Archival
8686: ,org_information6 -- Archival Type (Original or Correction Statement)
8687: FROM hr_organization_information
8688: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
8689: AND organization_id = g_gre_id
8690: AND org_information1 = g_year
8691: AND org_information2 = g_quarter

Line 8723: FROM hr_organization_information

8719:
8720: CURSOR c_select_prev_24qc(p_locked_pay_act_id_qc NUMBER)
8721: IS
8722: SELECT MAX(org_information3)
8723: FROM hr_organization_information
8724: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
8725: AND organization_id = g_gre_id
8726: AND org_information1 = g_year
8727: AND org_information2 = g_quarter

Line 9857: ( challan_no hr_organization_information.org_information1%TYPE

9853: AND pai.action_information1 = p_challan_number
9854: AND paa.payroll_action_id = p_24q_pay_action_id;
9855:
9856: TYPE t_challan_data IS RECORD
9857: ( challan_no hr_organization_information.org_information1%TYPE
9858: ,correction_type VARCHAR2(100)
9859: ,action_information_id NUMBER
9860: ,object_version_number NUMBER
9861: );