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

736: AND pai.action_information15 = 'A'
737: AND pai.source_id = p_element_entry_id
738: AND paa_24qc.payroll_action_id IN(
739: SELECT org_information3
740: FROM hr_organization_information
741: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
742: AND organization_id = g_gre_id
743: AND org_information1 = g_year
744: AND org_information2 = g_quarter

Line 807: FROM hr_organization_information

803: AND pai.action_context_id = paa.assignment_action_id
804: AND(
805: paa.payroll_action_id IN (
806: SELECT org_information3
807: FROM hr_organization_information
808: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
809: AND organization_id = g_gre_id
810: AND org_information1 = g_year
811: AND org_information2 = g_quarter

Line 848: FROM hr_organization_information

844: AND masters.assignment_id = pai.assignment_id
845: AND masters.assignment_action_id = pai.action_context_id
846: AND masters.payroll_action_id IN(
847: SELECT org_information3
848: FROM hr_organization_information
849: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
850: AND organization_id = g_gre_id
851: AND org_information1 = g_year
852: AND org_information2 = g_quarter

Line 875: FROM hr_organization_information

871: AND masters.assignment_id = pai.assignment_id
872: AND masters.assignment_action_id = pai.action_context_id
873: AND masters.payroll_action_id IN(
874: SELECT org_information3
875: FROM hr_organization_information
876: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
877: AND organization_id = g_gre_id
878: AND org_information1 = g_year
879: AND org_information2 = g_quarter

Line 937: FROM hr_organization_information

933: AND paa_24qc.assignment_id = pai.assignment_id
934: AND paa_24qc.assignment_action_id = pai.action_context_id
935: AND paa_24qc.payroll_action_id IN(
936: SELECT org_information3
937: FROM hr_organization_information
938: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
939: AND organization_id = g_gre_id
940: AND org_information1 = g_year
941: AND org_information2 = g_quarter

Line 965: FROM hr_organization_information

961: AND paa_24qc.assignment_action_id = pai.action_context_id
962: AND pai.source_id = entry.element_entry_id
963: AND paa_24qc.payroll_action_id IN(
964: SELECT org_information3
965: FROM hr_organization_information
966: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
967: AND organization_id = g_gre_id
968: AND org_information1 = g_year
969: AND org_information2 = g_quarter

Line 979: FROM hr_organization_information hoi

975: )
976: AND pay_in_utils.get_ee_value(entry.element_entry_id,'Challan or Voucher Number') IN
977: (
978: SELECT hoi.org_information3
979: FROM hr_organization_information hoi
980: ,hr_organization_units hou
981: WHERE hoi.organization_id = g_gre_id
982: AND hoi.organization_id = hou.organization_id
983: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 1004: FROM hr_organization_information hoi

1000: AND action_information2 = g_year||g_quarter
1001: AND action_information15 IN
1002: (
1003: SELECT hoi.org_information3
1004: FROM hr_organization_information hoi
1005: ,hr_organization_units hou
1006: WHERE hoi.organization_id = g_gre_id
1007: AND hoi.organization_id = hou.organization_id
1008: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 1037: FROM hr_organization_information hoi

1033: AND action_information2 = g_year||g_quarter
1034: AND action_information15 IN
1035: (
1036: SELECT hoi.org_information3
1037: FROM hr_organization_information hoi
1038: ,hr_organization_units hou
1039: WHERE hoi.organization_id = g_gre_id
1040: AND hoi.organization_id = hou.organization_id
1041: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 1142: FROM hr_organization_information

1138: AND pai_locking.action_context_id = paa.assignment_action_id
1139: AND paa.payroll_action_id IN
1140: (
1141: SELECT org_information3
1142: FROM hr_organization_information
1143: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
1144: AND organization_id = g_gre_id
1145: AND org_information1 = g_year
1146: AND org_information2 = g_quarter

Line 1171: FROM hr_organization_information

1167: AND pai.source_id = p_element_entry_id
1168: AND paa.payroll_action_id IN
1169: (
1170: SELECT org_information3
1171: FROM hr_organization_information
1172: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
1173: AND organization_id = g_gre_id
1174: AND org_information1 = g_year
1175: AND org_information2 = g_quarter

Line 1304: FROM hr_organization_information

1300: AND pai.action_context_id = paa.assignment_action_id
1301: AND paa.payroll_action_id IN
1302: (
1303: SELECT org_information3
1304: FROM hr_organization_information
1305: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
1306: AND organization_id = g_gre_id
1307: AND org_information1 = g_year
1308: AND org_information2 = g_quarter

Line 1328: FROM hr_organization_information

1324: AND pai.action_context_id = paa.assignment_action_id
1325: AND paa.payroll_action_id IN
1326: (
1327: SELECT org_information3
1328: FROM hr_organization_information
1329: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
1330: AND organization_id = g_gre_id
1331: AND org_information1 = g_year
1332: AND org_information2 = g_quarter

Line 1750: FROM hr_organization_information

1746: )
1747: AND(
1748: paa.payroll_action_id IN (
1749: SELECT org_information3
1750: FROM hr_organization_information
1751: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
1752: AND organization_id = g_gre_id
1753: AND org_information1 = g_year
1754: AND org_information2 = g_quarter

Line 1808: FROM hr_organization_information

1804: AND masters.assignment_id = pai.assignment_id
1805: AND masters.assignment_action_id = pai.action_context_id
1806: AND masters.payroll_action_id IN(
1807: SELECT org_information3
1808: FROM hr_organization_information
1809: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
1810: AND organization_id = g_gre_id
1811: AND org_information1 = g_year
1812: AND org_information2 = g_quarter

Line 1881: FROM hr_organization_information

1877: AND paa_24qc.assignment_id = pai.assignment_id
1878: AND paa_24qc.assignment_action_id = pai.action_context_id
1879: AND paa_24qc.payroll_action_id IN(
1880: SELECT org_information3
1881: FROM hr_organization_information
1882: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
1883: AND organization_id = g_gre_id
1884: AND org_information1 = g_year
1885: AND org_information2 = g_quarter

Line 1908: FROM hr_organization_information

1904: AND paa_24qc.assignment_id = pai.assignment_id
1905: AND paa_24qc.assignment_action_id = pai.action_context_id
1906: AND paa_24qc.payroll_action_id IN(
1907: SELECT org_information3
1908: FROM hr_organization_information
1909: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
1910: AND organization_id = g_gre_id
1911: AND org_information1 = g_year
1912: AND org_information2 = g_quarter

Line 1930: FROM hr_organization_information

1926: AND paa_24qc.assignment_id = pai.assignment_id
1927: AND paa_24qc.assignment_action_id = pai.action_context_id
1928: AND paa_24qc.payroll_action_id IN(
1929: SELECT org_information3
1930: FROM hr_organization_information
1931: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
1932: AND organization_id = g_gre_id
1933: AND org_information1 = g_year
1934: AND org_information2 = g_quarter

Line 2100: FROM hr_organization_information

2096: AND pai_locking.action_context_id = paa.assignment_action_id
2097: AND paa.payroll_action_id IN
2098: (
2099: SELECT org_information3
2100: FROM hr_organization_information
2101: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
2102: AND organization_id = g_gre_id
2103: AND org_information1 = g_year
2104: AND org_information2 = g_quarter

Line 2131: FROM hr_organization_information

2127: AND pai.source_id = p_source_id
2128: AND paa.payroll_action_id IN
2129: (
2130: SELECT org_information3
2131: FROM hr_organization_information
2132: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
2133: AND organization_id = g_gre_id
2134: AND org_information1 = g_year
2135: AND org_information2 = g_quarter

Line 2384: FROM hr_organization_information

2380: AND pai.action_context_id = paa.assignment_action_id
2381: AND paa.payroll_action_id IN
2382: (
2383: SELECT org_information3
2384: FROM hr_organization_information
2385: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
2386: AND organization_id = g_gre_id
2387: AND org_information1 = g_year
2388: AND org_information2 = g_quarter

Line 2410: FROM hr_organization_information

2406: AND pai.action_context_id = paa.assignment_action_id
2407: AND paa.payroll_action_id IN
2408: (
2409: SELECT org_information3
2410: FROM hr_organization_information
2411: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
2412: AND organization_id = g_gre_id
2413: AND org_information1 = g_year
2414: AND org_information2 = g_quarter

Line 2727: FROM hr_organization_information hoi

2723: ,hoi.org_information3 deductor_type
2724: ,hoi.org_information4 reg_org_id
2725: ,hoi.org_information7 division
2726: ,hou.location_id location_id
2727: FROM hr_organization_information hoi
2728: ,hr_organization_units hou
2729: WHERE hoi.organization_id = p_gre_id
2730: AND hoi.org_information_context = 'PER_IN_INCOME_TAX_DF'
2731: AND hou.organization_id = hoi.organization_id

Line 2739: FROM hr_organization_information hoi

2735: CURSOR c_reg_org_details(p_reg_org_id NUMBER)
2736: IS
2737: SELECT hoi.org_information3 pan
2738: ,hoi.org_information4 legal_name
2739: FROM hr_organization_information hoi
2740: ,hr_organization_units hou
2741: WHERE hoi.organization_id = p_reg_org_id
2742: AND hoi.org_information_context = 'PER_IN_COMPANY_DF'
2743: AND hou.organization_id = hoi.organization_id

Line 2781: FROM hr_organization_information hoi

2777: IS
2778: SELECT pep.person_id
2779: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) rep_name
2780: ,pep.email_address email_id
2781: FROM hr_organization_information hoi
2782: ,hr_organization_units hou
2783: ,per_people_f pep
2784: WHERE hoi.org_information_context = 'PER_IN_INCOME_TAX_REP_DF'
2785: AND hoi.organization_id = p_gre_id

Line 2808: l_reg_org_id hr_organization_information.org_information4%TYPE;

2804: AND phone_type = 'W1'
2805: AND g_qr_end_date BETWEEN date_from AND NVL(date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
2806:
2807:
2808: l_reg_org_id hr_organization_information.org_information4%TYPE;
2809: l_rep_person_id per_all_people_f.person_id%TYPE;
2810: l_procedure VARCHAR2(250);
2811: l_message VARCHAR2(250);
2812: BEGIN

Line 2904: FROM hr_organization_information

2900: AND pai.source_id = p_payroll_action_id
2901: AND pai.action_context_id IN
2902: (
2903: SELECT org_information3
2904: FROM hr_organization_information
2905: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
2906: AND organization_id = g_gre_id
2907: AND org_information1 = g_year
2908: AND org_information2 = g_quarter

Line 2988: l_tan_number hr_organization_information.org_information1%TYPE;

2984: --
2985: l_last_action_context_id NUMBER;
2986: l_dummy NUMBER;
2987: l_flag BOOLEAN;
2988: l_tan_number hr_organization_information.org_information1%TYPE;
2989: l_deductor_type hr_organization_information.org_information3%TYPE;
2990: l_branch_or_division hr_organization_information.org_information7%TYPE;
2991: l_org_location hr_organization_units.location_id%TYPE;
2992: l_pan_number hr_organization_information.org_information3%TYPE;

Line 2989: l_deductor_type hr_organization_information.org_information3%TYPE;

2985: l_last_action_context_id NUMBER;
2986: l_dummy NUMBER;
2987: l_flag BOOLEAN;
2988: l_tan_number hr_organization_information.org_information1%TYPE;
2989: l_deductor_type hr_organization_information.org_information3%TYPE;
2990: l_branch_or_division hr_organization_information.org_information7%TYPE;
2991: l_org_location hr_organization_units.location_id%TYPE;
2992: l_pan_number hr_organization_information.org_information3%TYPE;
2993: l_legal_name hr_organization_information.org_information4%TYPE;

Line 2990: l_branch_or_division hr_organization_information.org_information7%TYPE;

2986: l_dummy NUMBER;
2987: l_flag BOOLEAN;
2988: l_tan_number hr_organization_information.org_information1%TYPE;
2989: l_deductor_type hr_organization_information.org_information3%TYPE;
2990: l_branch_or_division hr_organization_information.org_information7%TYPE;
2991: l_org_location hr_organization_units.location_id%TYPE;
2992: l_pan_number hr_organization_information.org_information3%TYPE;
2993: l_legal_name hr_organization_information.org_information4%TYPE;
2994: l_rep_name per_all_people_f.full_name%TYPE;

Line 2992: l_pan_number hr_organization_information.org_information3%TYPE;

2988: l_tan_number hr_organization_information.org_information1%TYPE;
2989: l_deductor_type hr_organization_information.org_information3%TYPE;
2990: l_branch_or_division hr_organization_information.org_information7%TYPE;
2991: l_org_location hr_organization_units.location_id%TYPE;
2992: l_pan_number hr_organization_information.org_information3%TYPE;
2993: l_legal_name hr_organization_information.org_information4%TYPE;
2994: l_rep_name per_all_people_f.full_name%TYPE;
2995: l_rep_position per_all_positions.name%TYPE;
2996: l_rep_location hr_organization_units.location_id%TYPE;

Line 2993: l_legal_name hr_organization_information.org_information4%TYPE;

2989: l_deductor_type hr_organization_information.org_information3%TYPE;
2990: l_branch_or_division hr_organization_information.org_information7%TYPE;
2991: l_org_location hr_organization_units.location_id%TYPE;
2992: l_pan_number hr_organization_information.org_information3%TYPE;
2993: l_legal_name hr_organization_information.org_information4%TYPE;
2994: l_rep_name per_all_people_f.full_name%TYPE;
2995: l_rep_position per_all_positions.name%TYPE;
2996: l_rep_location hr_organization_units.location_id%TYPE;
2997: l_rep_email_id per_all_people_f.email_address%TYPE;

Line 3203: FROM hr_organization_information hoi_bank

3199: hoi.org_information8 education_cess,
3200: hoi.org_information10 other,
3201: hoi.org_information9 interest,
3202: (SELECT hoi_bank.org_information4
3203: FROM hr_organization_information hoi_bank
3204: WHERE hoi_bank.organization_id = p_gre_id
3205: AND hoi_bank.org_information_context = 'PER_IN_CHALLAN_BANK'
3206: AND hoi_bank.org_information_id = hoi.org_information5
3207: ) bank_branch_code,

Line 3210: FROM hr_organization_information hoi

3206: AND hoi_bank.org_information_id = hoi.org_information5
3207: ) bank_branch_code,
3208: hoi.org_information11 cheque_dd_num,
3209: hoi.org_information_id org_information_id
3210: FROM hr_organization_information hoi
3211: WHERE hoi.org_information_id IN
3212: (
3213: SELECT hoi.org_information_id
3214: FROM hr_organization_information hoi

Line 3214: FROM hr_organization_information hoi

3210: FROM hr_organization_information hoi
3211: WHERE hoi.org_information_id IN
3212: (
3213: SELECT hoi.org_information_id
3214: FROM hr_organization_information hoi
3215: ,hr_organization_units hou
3216: WHERE hoi.organization_id = p_gre_id
3217: AND hoi.organization_id = hou.organization_id
3218: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 3245: FROM hr_organization_information hoi_bank

3241: hoi.org_information8 education_cess,
3242: hoi.org_information10 other,
3243: hoi.org_information9 interest,
3244: (SELECT hoi_bank.org_information4
3245: FROM hr_organization_information hoi_bank
3246: WHERE hoi_bank.organization_id = p_gre_id
3247: AND hoi_bank.org_information_context = 'PER_IN_CHALLAN_BANK'
3248: AND hoi_bank.org_information_id = hoi.org_information5
3249: ) bank_branch_code,

Line 3252: FROM hr_organization_information hoi

3248: AND hoi_bank.org_information_id = hoi.org_information5
3249: ) bank_branch_code,
3250: hoi.org_information11 cheque_dd_num,
3251: hoi.org_information_id org_information_id
3252: FROM hr_organization_information hoi
3253: WHERE hoi.org_information_id IN
3254: (
3255: SELECT hoi.org_information_id
3256: FROM hr_organization_information hoi

Line 3256: FROM hr_organization_information hoi

3252: FROM hr_organization_information hoi
3253: WHERE hoi.org_information_id IN
3254: (
3255: SELECT hoi.org_information_id
3256: FROM hr_organization_information hoi
3257: ,hr_organization_units hou
3258: WHERE hoi.organization_id = p_gre_id
3259: AND hoi.organization_id = hou.organization_id
3260: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 3294: FROM hr_organization_information

3290: AND action_information_category = p_act_info_category
3291: AND action_context_id IN
3292: (
3293: SELECT org_information3
3294: FROM hr_organization_information
3295: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
3296: AND organization_id = g_gre_id
3297: AND org_information1 = g_year
3298: AND org_information2 = g_quarter

Line 3344: FROM hr_organization_information

3340: AND action_information_category = p_act_info_category
3341: AND action_context_id IN
3342: (
3343: SELECT org_information3
3344: FROM hr_organization_information
3345: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
3346: AND organization_id = g_gre_id
3347: AND org_information1 = g_year
3348: AND org_information2 = g_quarter

Line 3368: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;

3364: ,p_payroll_action_id
3365: ) = p_payroll_action_id
3366: ORDER BY action_information_id DESC;
3367:
3368: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;
3369: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
3370: l_amount hr_organization_information.org_information4%TYPE;
3371: l_surcharge hr_organization_information.org_information7%TYPE;
3372: l_education_cess hr_organization_information.org_information8%TYPE;

Line 3369: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;

3365: ) = p_payroll_action_id
3366: ORDER BY action_information_id DESC;
3367:
3368: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;
3369: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
3370: l_amount hr_organization_information.org_information4%TYPE;
3371: l_surcharge hr_organization_information.org_information7%TYPE;
3372: l_education_cess hr_organization_information.org_information8%TYPE;
3373: l_interest hr_organization_information.org_information9%TYPE;

Line 3370: l_amount hr_organization_information.org_information4%TYPE;

3366: ORDER BY action_information_id DESC;
3367:
3368: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;
3369: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
3370: l_amount hr_organization_information.org_information4%TYPE;
3371: l_surcharge hr_organization_information.org_information7%TYPE;
3372: l_education_cess hr_organization_information.org_information8%TYPE;
3373: l_interest hr_organization_information.org_information9%TYPE;
3374: l_others hr_organization_information.org_information10%TYPE;

Line 3371: l_surcharge hr_organization_information.org_information7%TYPE;

3367:
3368: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;
3369: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
3370: l_amount hr_organization_information.org_information4%TYPE;
3371: l_surcharge hr_organization_information.org_information7%TYPE;
3372: l_education_cess hr_organization_information.org_information8%TYPE;
3373: l_interest hr_organization_information.org_information9%TYPE;
3374: l_others hr_organization_information.org_information10%TYPE;
3375: l_bank_branch_code hr_organization_information.org_information4%TYPE;

Line 3372: l_education_cess hr_organization_information.org_information8%TYPE;

3368: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;
3369: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
3370: l_amount hr_organization_information.org_information4%TYPE;
3371: l_surcharge hr_organization_information.org_information7%TYPE;
3372: l_education_cess hr_organization_information.org_information8%TYPE;
3373: l_interest hr_organization_information.org_information9%TYPE;
3374: l_others hr_organization_information.org_information10%TYPE;
3375: l_bank_branch_code hr_organization_information.org_information4%TYPE;
3376: l_cheque_dd_num hr_organization_information.org_information11%TYPE;

Line 3373: l_interest hr_organization_information.org_information9%TYPE;

3369: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
3370: l_amount hr_organization_information.org_information4%TYPE;
3371: l_surcharge hr_organization_information.org_information7%TYPE;
3372: l_education_cess hr_organization_information.org_information8%TYPE;
3373: l_interest hr_organization_information.org_information9%TYPE;
3374: l_others hr_organization_information.org_information10%TYPE;
3375: l_bank_branch_code hr_organization_information.org_information4%TYPE;
3376: l_cheque_dd_num hr_organization_information.org_information11%TYPE;
3377: l_org_information_id NUMBER;

Line 3374: l_others hr_organization_information.org_information10%TYPE;

3370: l_amount hr_organization_information.org_information4%TYPE;
3371: l_surcharge hr_organization_information.org_information7%TYPE;
3372: l_education_cess hr_organization_information.org_information8%TYPE;
3373: l_interest hr_organization_information.org_information9%TYPE;
3374: l_others hr_organization_information.org_information10%TYPE;
3375: l_bank_branch_code hr_organization_information.org_information4%TYPE;
3376: l_cheque_dd_num hr_organization_information.org_information11%TYPE;
3377: l_org_information_id NUMBER;
3378: l_action_information_id NUMBER;

Line 3375: l_bank_branch_code hr_organization_information.org_information4%TYPE;

3371: l_surcharge hr_organization_information.org_information7%TYPE;
3372: l_education_cess hr_organization_information.org_information8%TYPE;
3373: l_interest hr_organization_information.org_information9%TYPE;
3374: l_others hr_organization_information.org_information10%TYPE;
3375: l_bank_branch_code hr_organization_information.org_information4%TYPE;
3376: l_cheque_dd_num hr_organization_information.org_information11%TYPE;
3377: l_org_information_id NUMBER;
3378: l_action_information_id NUMBER;
3379:

Line 3376: l_cheque_dd_num hr_organization_information.org_information11%TYPE;

3372: l_education_cess hr_organization_information.org_information8%TYPE;
3373: l_interest hr_organization_information.org_information9%TYPE;
3374: l_others hr_organization_information.org_information10%TYPE;
3375: l_bank_branch_code hr_organization_information.org_information4%TYPE;
3376: l_cheque_dd_num hr_organization_information.org_information11%TYPE;
3377: l_org_information_id NUMBER;
3378: l_action_information_id NUMBER;
3379:
3380: l_transfer_voucher_number_1 hr_organization_information.org_information3%TYPE;

Line 3380: l_transfer_voucher_number_1 hr_organization_information.org_information3%TYPE;

3376: l_cheque_dd_num hr_organization_information.org_information11%TYPE;
3377: l_org_information_id NUMBER;
3378: l_action_information_id NUMBER;
3379:
3380: l_transfer_voucher_number_1 hr_organization_information.org_information3%TYPE;
3381: l_transfer_voucher_date_1 hr_organization_information.org_information2%TYPE;
3382: l_amount_1 hr_organization_information.org_information4%TYPE;
3383: l_surcharge_1 hr_organization_information.org_information7%TYPE;
3384: l_education_cess_1 hr_organization_information.org_information8%TYPE;

Line 3381: l_transfer_voucher_date_1 hr_organization_information.org_information2%TYPE;

3377: l_org_information_id NUMBER;
3378: l_action_information_id NUMBER;
3379:
3380: l_transfer_voucher_number_1 hr_organization_information.org_information3%TYPE;
3381: l_transfer_voucher_date_1 hr_organization_information.org_information2%TYPE;
3382: l_amount_1 hr_organization_information.org_information4%TYPE;
3383: l_surcharge_1 hr_organization_information.org_information7%TYPE;
3384: l_education_cess_1 hr_organization_information.org_information8%TYPE;
3385: l_interest_1 hr_organization_information.org_information9%TYPE;

Line 3382: l_amount_1 hr_organization_information.org_information4%TYPE;

3378: l_action_information_id NUMBER;
3379:
3380: l_transfer_voucher_number_1 hr_organization_information.org_information3%TYPE;
3381: l_transfer_voucher_date_1 hr_organization_information.org_information2%TYPE;
3382: l_amount_1 hr_organization_information.org_information4%TYPE;
3383: l_surcharge_1 hr_organization_information.org_information7%TYPE;
3384: l_education_cess_1 hr_organization_information.org_information8%TYPE;
3385: l_interest_1 hr_organization_information.org_information9%TYPE;
3386: l_others_1 hr_organization_information.org_information10%TYPE;

Line 3383: l_surcharge_1 hr_organization_information.org_information7%TYPE;

3379:
3380: l_transfer_voucher_number_1 hr_organization_information.org_information3%TYPE;
3381: l_transfer_voucher_date_1 hr_organization_information.org_information2%TYPE;
3382: l_amount_1 hr_organization_information.org_information4%TYPE;
3383: l_surcharge_1 hr_organization_information.org_information7%TYPE;
3384: l_education_cess_1 hr_organization_information.org_information8%TYPE;
3385: l_interest_1 hr_organization_information.org_information9%TYPE;
3386: l_others_1 hr_organization_information.org_information10%TYPE;
3387: l_bank_branch_code_1 hr_organization_information.org_information4%TYPE;

Line 3384: l_education_cess_1 hr_organization_information.org_information8%TYPE;

3380: l_transfer_voucher_number_1 hr_organization_information.org_information3%TYPE;
3381: l_transfer_voucher_date_1 hr_organization_information.org_information2%TYPE;
3382: l_amount_1 hr_organization_information.org_information4%TYPE;
3383: l_surcharge_1 hr_organization_information.org_information7%TYPE;
3384: l_education_cess_1 hr_organization_information.org_information8%TYPE;
3385: l_interest_1 hr_organization_information.org_information9%TYPE;
3386: l_others_1 hr_organization_information.org_information10%TYPE;
3387: l_bank_branch_code_1 hr_organization_information.org_information4%TYPE;
3388: l_cheque_dd_num_1 hr_organization_information.org_information11%TYPE;

Line 3385: l_interest_1 hr_organization_information.org_information9%TYPE;

3381: l_transfer_voucher_date_1 hr_organization_information.org_information2%TYPE;
3382: l_amount_1 hr_organization_information.org_information4%TYPE;
3383: l_surcharge_1 hr_organization_information.org_information7%TYPE;
3384: l_education_cess_1 hr_organization_information.org_information8%TYPE;
3385: l_interest_1 hr_organization_information.org_information9%TYPE;
3386: l_others_1 hr_organization_information.org_information10%TYPE;
3387: l_bank_branch_code_1 hr_organization_information.org_information4%TYPE;
3388: l_cheque_dd_num_1 hr_organization_information.org_information11%TYPE;
3389: l_org_information_id_1 NUMBER;

Line 3386: l_others_1 hr_organization_information.org_information10%TYPE;

3382: l_amount_1 hr_organization_information.org_information4%TYPE;
3383: l_surcharge_1 hr_organization_information.org_information7%TYPE;
3384: l_education_cess_1 hr_organization_information.org_information8%TYPE;
3385: l_interest_1 hr_organization_information.org_information9%TYPE;
3386: l_others_1 hr_organization_information.org_information10%TYPE;
3387: l_bank_branch_code_1 hr_organization_information.org_information4%TYPE;
3388: l_cheque_dd_num_1 hr_organization_information.org_information11%TYPE;
3389: l_org_information_id_1 NUMBER;
3390: l_dummy_boolean BOOLEAN;

Line 3387: l_bank_branch_code_1 hr_organization_information.org_information4%TYPE;

3383: l_surcharge_1 hr_organization_information.org_information7%TYPE;
3384: l_education_cess_1 hr_organization_information.org_information8%TYPE;
3385: l_interest_1 hr_organization_information.org_information9%TYPE;
3386: l_others_1 hr_organization_information.org_information10%TYPE;
3387: l_bank_branch_code_1 hr_organization_information.org_information4%TYPE;
3388: l_cheque_dd_num_1 hr_organization_information.org_information11%TYPE;
3389: l_org_information_id_1 NUMBER;
3390: l_dummy_boolean BOOLEAN;
3391: l_dummy NUMBER;

Line 3388: l_cheque_dd_num_1 hr_organization_information.org_information11%TYPE;

3384: l_education_cess_1 hr_organization_information.org_information8%TYPE;
3385: l_interest_1 hr_organization_information.org_information9%TYPE;
3386: l_others_1 hr_organization_information.org_information10%TYPE;
3387: l_bank_branch_code_1 hr_organization_information.org_information4%TYPE;
3388: l_cheque_dd_num_1 hr_organization_information.org_information11%TYPE;
3389: l_org_information_id_1 NUMBER;
3390: l_dummy_boolean BOOLEAN;
3391: l_dummy NUMBER;
3392: l_procedure VARCHAR2(250);

Line 4288: FROM hr_organization_information

4284: AND paa.payroll_action_id = p_24qa_pay_act_id
4285: AND paa_master.assignment_action_id = pai.action_context_id
4286: AND paa_master.payroll_action_id IN(
4287: SELECT org_information3
4288: FROM hr_organization_information
4289: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
4290: AND organization_id = g_gre_id
4291: AND org_information1 = g_year
4292: AND org_information2 = g_quarter

Line 4337: FROM hr_organization_information

4333: AND paa.payroll_action_id = p_24qa_pay_act_id
4334: AND paa_master.assignment_action_id = pai.action_context_id
4335: AND paa_master.payroll_action_id IN(
4336: SELECT org_information3
4337: FROM hr_organization_information
4338: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
4339: AND organization_id = g_gre_id
4340: AND org_information1 = g_year
4341: AND org_information2 = g_quarter

Line 4921: FROM hr_organization_information

4917: AND pai.action_context_id = paa.assignment_action_id
4918: AND paa.payroll_action_id = p_24qa_pay_act_id
4919: AND paa.payroll_action_id IN(
4920: SELECT org_information3
4921: FROM hr_organization_information
4922: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
4923: AND organization_id = g_gre_id
4924: AND org_information1 = g_year
4925: AND org_information2 = g_quarter

Line 4950: FROM hr_organization_information

4946: AND paa.payroll_action_id = p_24qa_pay_act_id
4947: AND paa_master.assignment_action_id = pai.action_context_id
4948: AND paa_master.payroll_action_id IN(
4949: SELECT org_information3
4950: FROM hr_organization_information
4951: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
4952: AND organization_id = g_gre_id
4953: AND org_information1 = g_year
4954: AND org_information2 = g_quarter

Line 4971: FROM hr_organization_information

4967: AND pai.action_context_id = paa.assignment_action_id
4968: AND paa.payroll_action_id = p_24qa_pay_act_id
4969: AND paa.payroll_action_id IN(
4970: SELECT org_information3
4971: FROM hr_organization_information
4972: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
4973: AND organization_id = g_gre_id
4974: AND org_information1 = g_year
4975: AND org_information2 = g_quarter

Line 4997: FROM hr_organization_information

4993: AND paa.payroll_action_id = p_24qa_pay_act_id
4994: AND paa_master.assignment_action_id = pai.action_context_id
4995: AND paa_master.payroll_action_id IN(
4996: SELECT org_information3
4997: FROM hr_organization_information
4998: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
4999: AND organization_id = g_gre_id
5000: AND org_information1 = g_year
5001: AND org_information2 = g_quarter

Line 5101: FROM hr_organization_information

5097: AND paa.payroll_action_id = p_24qa_pay_act_id
5098: AND paa_master.assignment_action_id = pai.action_context_id
5099: AND paa_master.payroll_action_id IN(
5100: SELECT org_information3
5101: FROM hr_organization_information
5102: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
5103: AND organization_id = g_gre_id
5104: AND org_information1 = g_year
5105: AND org_information2 = g_quarter

Line 6345: FROM hr_organization_information

6341: AND paa.payroll_action_id = p_24qa_pay_act_id
6342: AND paa_master.assignment_action_id = pai.action_context_id
6343: AND paa_master.payroll_action_id IN(
6344: SELECT org_information3
6345: FROM hr_organization_information
6346: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
6347: AND organization_id = g_gre_id
6348: AND org_information1 = g_year
6349: AND org_information2 = g_quarter

Line 6366: FROM hr_organization_information

6362: AND pai.action_context_id = paa.assignment_action_id
6363: AND paa.payroll_action_id = p_24qa_pay_act_id
6364: AND paa.payroll_action_id IN(
6365: SELECT org_information3
6366: FROM hr_organization_information
6367: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
6368: AND organization_id = g_gre_id
6369: AND org_information1 = g_year
6370: AND org_information2 = g_quarter

Line 6873: FROM hr_organization_information

6869: AND action_information15 = p_24qa_pay_act_id
6870: AND action_information1 = p_transfer_voucher_number
6871: AND action_context_id IN(
6872: SELECT org_information3
6873: FROM hr_organization_information
6874: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
6875: AND organization_id = g_gre_id
6876: AND org_information1 = g_year
6877: AND org_information2 = g_quarter

Line 6910: FROM hr_organization_information hoi_bank

6906: hoi.org_information8 education_cess,
6907: hoi.org_information10 other,
6908: hoi.org_information9 interest,
6909: (SELECT hoi_bank.org_information4
6910: FROM hr_organization_information hoi_bank
6911: WHERE hoi_bank.organization_id = g_gre_id
6912: AND hoi_bank.org_information_context = 'PER_IN_CHALLAN_BANK'
6913: AND hoi_bank.org_information_id = hoi.org_information5
6914: ) bank_branch_code,

Line 6918: FROM hr_organization_information hoi

6914: ) bank_branch_code,
6915: hoi.org_information11 cheque_dd_num,
6916: hoi.org_information12 book_entry,
6917: hoi.org_information_id org_information_id
6918: FROM hr_organization_information hoi
6919: WHERE hoi.org_information_id IN
6920: (
6921: SELECT hoi.org_information_id
6922: FROM hr_organization_information hoi

Line 6922: FROM hr_organization_information hoi

6918: FROM hr_organization_information hoi
6919: WHERE hoi.org_information_id IN
6920: (
6921: SELECT hoi.org_information_id
6922: FROM hr_organization_information hoi
6923: ,hr_organization_units hou
6924: WHERE hoi.organization_id = g_gre_id
6925: AND hoi.organization_id = hou.organization_id
6926: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 7104: FROM hr_organization_information hoi_bank

7100: hoi.org_information8 education_cess,
7101: hoi.org_information10 other,
7102: hoi.org_information9 interest,
7103: (SELECT hoi_bank.org_information4
7104: FROM hr_organization_information hoi_bank
7105: WHERE hoi_bank.organization_id = g_gre_id
7106: AND hoi_bank.org_information_context = 'PER_IN_CHALLAN_BANK'
7107: AND hoi_bank.org_information_id = hoi.org_information5
7108: ) bank_branch_code,

Line 7112: FROM hr_organization_information hoi

7108: ) bank_branch_code,
7109: hoi.org_information11 cheque_dd_num,
7110: hoi.org_information12 book_entry,
7111: hoi.org_information_id org_information_id
7112: FROM hr_organization_information hoi
7113: WHERE hoi.org_information_id IN
7114: (
7115: SELECT hoi.org_information_id
7116: FROM hr_organization_information hoi

Line 7116: FROM hr_organization_information hoi

7112: FROM hr_organization_information hoi
7113: WHERE hoi.org_information_id IN
7114: (
7115: SELECT hoi.org_information_id
7116: FROM hr_organization_information hoi
7117: ,hr_organization_units hou
7118: WHERE hoi.organization_id = g_gre_id
7119: AND hoi.organization_id = hou.organization_id
7120: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 7131: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;

7127: OR
7128: (hoi.org_information_id = p_org_information_id)
7129: );
7130:
7131: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;
7132: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
7133: l_amount hr_organization_information.org_information4%TYPE;
7134: l_surcharge hr_organization_information.org_information7%TYPE;
7135: l_education_cess hr_organization_information.org_information8%TYPE;

Line 7132: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;

7128: (hoi.org_information_id = p_org_information_id)
7129: );
7130:
7131: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;
7132: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
7133: l_amount hr_organization_information.org_information4%TYPE;
7134: l_surcharge hr_organization_information.org_information7%TYPE;
7135: l_education_cess hr_organization_information.org_information8%TYPE;
7136: l_others hr_organization_information.org_information10%TYPE;

Line 7133: l_amount hr_organization_information.org_information4%TYPE;

7129: );
7130:
7131: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;
7132: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
7133: l_amount hr_organization_information.org_information4%TYPE;
7134: l_surcharge hr_organization_information.org_information7%TYPE;
7135: l_education_cess hr_organization_information.org_information8%TYPE;
7136: l_others hr_organization_information.org_information10%TYPE;
7137: l_interest hr_organization_information.org_information9%TYPE;

Line 7134: l_surcharge hr_organization_information.org_information7%TYPE;

7130:
7131: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;
7132: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
7133: l_amount hr_organization_information.org_information4%TYPE;
7134: l_surcharge hr_organization_information.org_information7%TYPE;
7135: l_education_cess hr_organization_information.org_information8%TYPE;
7136: l_others hr_organization_information.org_information10%TYPE;
7137: l_interest hr_organization_information.org_information9%TYPE;
7138: l_bank_branch_code hr_organization_information.org_information4%TYPE;

Line 7135: l_education_cess hr_organization_information.org_information8%TYPE;

7131: l_transfer_voucher_number hr_organization_information.org_information3%TYPE;
7132: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
7133: l_amount hr_organization_information.org_information4%TYPE;
7134: l_surcharge hr_organization_information.org_information7%TYPE;
7135: l_education_cess hr_organization_information.org_information8%TYPE;
7136: l_others hr_organization_information.org_information10%TYPE;
7137: l_interest hr_organization_information.org_information9%TYPE;
7138: l_bank_branch_code hr_organization_information.org_information4%TYPE;
7139: l_cheque_dd_num hr_organization_information.org_information11%TYPE;

Line 7136: l_others hr_organization_information.org_information10%TYPE;

7132: l_transfer_voucher_date hr_organization_information.org_information2%TYPE;
7133: l_amount hr_organization_information.org_information4%TYPE;
7134: l_surcharge hr_organization_information.org_information7%TYPE;
7135: l_education_cess hr_organization_information.org_information8%TYPE;
7136: l_others hr_organization_information.org_information10%TYPE;
7137: l_interest hr_organization_information.org_information9%TYPE;
7138: l_bank_branch_code hr_organization_information.org_information4%TYPE;
7139: l_cheque_dd_num hr_organization_information.org_information11%TYPE;
7140: l_book_entry hr_organization_information.org_information12%TYPE;

Line 7137: l_interest hr_organization_information.org_information9%TYPE;

7133: l_amount hr_organization_information.org_information4%TYPE;
7134: l_surcharge hr_organization_information.org_information7%TYPE;
7135: l_education_cess hr_organization_information.org_information8%TYPE;
7136: l_others hr_organization_information.org_information10%TYPE;
7137: l_interest hr_organization_information.org_information9%TYPE;
7138: l_bank_branch_code hr_organization_information.org_information4%TYPE;
7139: l_cheque_dd_num hr_organization_information.org_information11%TYPE;
7140: l_book_entry hr_organization_information.org_information12%TYPE;
7141: l_org_information_id NUMBER;

Line 7138: l_bank_branch_code hr_organization_information.org_information4%TYPE;

7134: l_surcharge hr_organization_information.org_information7%TYPE;
7135: l_education_cess hr_organization_information.org_information8%TYPE;
7136: l_others hr_organization_information.org_information10%TYPE;
7137: l_interest hr_organization_information.org_information9%TYPE;
7138: l_bank_branch_code hr_organization_information.org_information4%TYPE;
7139: l_cheque_dd_num hr_organization_information.org_information11%TYPE;
7140: l_book_entry hr_organization_information.org_information12%TYPE;
7141: l_org_information_id NUMBER;
7142: l_previous_total_amount NUMBER;

Line 7139: l_cheque_dd_num hr_organization_information.org_information11%TYPE;

7135: l_education_cess hr_organization_information.org_information8%TYPE;
7136: l_others hr_organization_information.org_information10%TYPE;
7137: l_interest hr_organization_information.org_information9%TYPE;
7138: l_bank_branch_code hr_organization_information.org_information4%TYPE;
7139: l_cheque_dd_num hr_organization_information.org_information11%TYPE;
7140: l_book_entry hr_organization_information.org_information12%TYPE;
7141: l_org_information_id NUMBER;
7142: l_previous_total_amount NUMBER;
7143: l_challan_record_number NUMBER;

Line 7140: l_book_entry hr_organization_information.org_information12%TYPE;

7136: l_others hr_organization_information.org_information10%TYPE;
7137: l_interest hr_organization_information.org_information9%TYPE;
7138: l_bank_branch_code hr_organization_information.org_information4%TYPE;
7139: l_cheque_dd_num hr_organization_information.org_information11%TYPE;
7140: l_book_entry hr_organization_information.org_information12%TYPE;
7141: l_org_information_id NUMBER;
7142: l_previous_total_amount NUMBER;
7143: l_challan_record_number NUMBER;
7144: l_action_info_id NUMBER;

Line 7166: FROM hr_organization_information

7162: AND action_information2 = g_year||g_quarter
7163: AND action_context_id = p_24qa_pay_act_id
7164: AND action_context_id IN(
7165: SELECT org_information3
7166: FROM hr_organization_information
7167: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
7168: AND organization_id = g_gre_id
7169: AND org_information1 = g_year
7170: AND org_information2 = g_quarter

Line 7185: FROM hr_organization_information

7181: AND action_information2 = g_year||g_quarter
7182: AND action_information15 = p_24qa_pay_act_id
7183: AND action_context_id IN(
7184: SELECT org_information3
7185: FROM hr_organization_information
7186: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
7187: AND organization_id = g_gre_id
7188: AND org_information1 = g_year
7189: AND org_information2 = g_quarter

Line 7294: FROM hr_organization_information

7290: source_id = g_challan_data_upd(i).org_information_id
7291: )
7292: AND p_24qa_pay_act_id IN(
7293: SELECT org_information3
7294: FROM hr_organization_information
7295: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
7296: AND organization_id = g_gre_id
7297: AND org_information1 = g_year
7298: AND org_information2 = g_quarter

Line 7322: FROM hr_organization_information

7318: source_id = g_challan_data_upd(i).org_information_id
7319: )
7320: AND action_information15 IN(
7321: SELECT org_information3
7322: FROM hr_organization_information
7323: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
7324: AND organization_id = g_gre_id
7325: AND org_information1 = g_year
7326: AND org_information2 = g_quarter

Line 7425: FROM hr_organization_information

7421: IS
7422: CURSOR c_get_act_ctxt_id
7423: IS
7424: SELECT org_information3
7425: FROM hr_organization_information
7426: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
7427: AND organization_id = g_gre_id
7428: AND org_information1 = g_year
7429: AND org_information4 = g_cancel_ref_number;

Line 7564: l_tan_number hr_organization_information.org_information1%TYPE;

7560: AND action_information2 = p_tan_number
7561: AND action_information3 = g_year||g_quarter
7562: ORDER BY action_context_id DESC;
7563:
7564: l_tan_number hr_organization_information.org_information1%TYPE;
7565: l_deductor_type hr_organization_information.org_information3%TYPE;
7566: l_branch_or_division hr_organization_information.org_information7%TYPE;
7567: l_org_location hr_organization_units.location_id%TYPE;
7568: l_pan_number hr_organization_information.org_information3%TYPE;

Line 7565: l_deductor_type hr_organization_information.org_information3%TYPE;

7561: AND action_information3 = g_year||g_quarter
7562: ORDER BY action_context_id DESC;
7563:
7564: l_tan_number hr_organization_information.org_information1%TYPE;
7565: l_deductor_type hr_organization_information.org_information3%TYPE;
7566: l_branch_or_division hr_organization_information.org_information7%TYPE;
7567: l_org_location hr_organization_units.location_id%TYPE;
7568: l_pan_number hr_organization_information.org_information3%TYPE;
7569: l_legal_name hr_organization_information.org_information4%TYPE;

Line 7566: l_branch_or_division hr_organization_information.org_information7%TYPE;

7562: ORDER BY action_context_id DESC;
7563:
7564: l_tan_number hr_organization_information.org_information1%TYPE;
7565: l_deductor_type hr_organization_information.org_information3%TYPE;
7566: l_branch_or_division hr_organization_information.org_information7%TYPE;
7567: l_org_location hr_organization_units.location_id%TYPE;
7568: l_pan_number hr_organization_information.org_information3%TYPE;
7569: l_legal_name hr_organization_information.org_information4%TYPE;
7570: l_rep_name per_all_people_f.full_name%TYPE;

Line 7568: l_pan_number hr_organization_information.org_information3%TYPE;

7564: l_tan_number hr_organization_information.org_information1%TYPE;
7565: l_deductor_type hr_organization_information.org_information3%TYPE;
7566: l_branch_or_division hr_organization_information.org_information7%TYPE;
7567: l_org_location hr_organization_units.location_id%TYPE;
7568: l_pan_number hr_organization_information.org_information3%TYPE;
7569: l_legal_name hr_organization_information.org_information4%TYPE;
7570: l_rep_name per_all_people_f.full_name%TYPE;
7571: l_rep_position per_all_positions.name%TYPE;
7572: l_rep_location hr_organization_units.location_id%TYPE;

Line 7569: l_legal_name hr_organization_information.org_information4%TYPE;

7565: l_deductor_type hr_organization_information.org_information3%TYPE;
7566: l_branch_or_division hr_organization_information.org_information7%TYPE;
7567: l_org_location hr_organization_units.location_id%TYPE;
7568: l_pan_number hr_organization_information.org_information3%TYPE;
7569: l_legal_name hr_organization_information.org_information4%TYPE;
7570: l_rep_name per_all_people_f.full_name%TYPE;
7571: l_rep_position per_all_positions.name%TYPE;
7572: l_rep_location hr_organization_units.location_id%TYPE;
7573: l_rep_email_id per_all_people_f.email_address%TYPE;

Line 7581: l_previous_org_legal_name hr_organization_information.org_information4%TYPE;

7577: l_action_info_id NUMBER;
7578: l_ovn NUMBER;
7579: l_new_nil_challan VARCHAR2(1);
7580: l_old_nil_challan VARCHAR2(1);
7581: l_previous_org_legal_name hr_organization_information.org_information4%TYPE;
7582: l_previous_deductor_type hr_organization_information.org_information3%TYPE;
7583: l_batch_upd_indicator NUMBER;
7584: i NUMBER;
7585: l_dummy NUMBER;

Line 7582: l_previous_deductor_type hr_organization_information.org_information3%TYPE;

7578: l_ovn NUMBER;
7579: l_new_nil_challan VARCHAR2(1);
7580: l_old_nil_challan VARCHAR2(1);
7581: l_previous_org_legal_name hr_organization_information.org_information4%TYPE;
7582: l_previous_deductor_type hr_organization_information.org_information3%TYPE;
7583: l_batch_upd_indicator NUMBER;
7584: i NUMBER;
7585: l_dummy NUMBER;
7586: l_flag NUMBER := -1;

Line 7865: FROM hr_organization_information

7861:
7862: CURSOR c_select_prev_24qc
7863: IS
7864: SELECT MAX(org_information3)
7865: FROM hr_organization_information
7866: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
7867: AND organization_id = g_gre_id
7868: AND org_information1 = g_year
7869: AND org_information2 = g_quarter

Line 8059: FROM hr_organization_information

8055: AND pai.action_information1 = p_challan_number
8056: AND pai.action_context_id IN
8057: (
8058: SELECT org_information3
8059: FROM hr_organization_information
8060: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
8061: AND organization_id = g_gre_id
8062: AND org_information1 = g_year
8063: AND org_information2 = g_quarter

Line 8083: l_tan_number hr_organization_information.org_information1%TYPE;

8079: AND action_information3 = g_year||g_quarter
8080: ORDER BY action_context_id DESC;
8081:
8082: l_challan_deductee_no VARCHAR2(250);
8083: l_tan_number hr_organization_information.org_information1%TYPE;
8084: l_deductor_type hr_organization_information.org_information3%TYPE;
8085: l_branch_or_division hr_organization_information.org_information7%TYPE;
8086: l_org_location hr_organization_units.location_id%TYPE;
8087: l_pan_number hr_organization_information.org_information3%TYPE;

Line 8084: l_deductor_type hr_organization_information.org_information3%TYPE;

8080: ORDER BY action_context_id DESC;
8081:
8082: l_challan_deductee_no VARCHAR2(250);
8083: l_tan_number hr_organization_information.org_information1%TYPE;
8084: l_deductor_type hr_organization_information.org_information3%TYPE;
8085: l_branch_or_division hr_organization_information.org_information7%TYPE;
8086: l_org_location hr_organization_units.location_id%TYPE;
8087: l_pan_number hr_organization_information.org_information3%TYPE;
8088: l_legal_name hr_organization_information.org_information4%TYPE;

Line 8085: l_branch_or_division hr_organization_information.org_information7%TYPE;

8081:
8082: l_challan_deductee_no VARCHAR2(250);
8083: l_tan_number hr_organization_information.org_information1%TYPE;
8084: l_deductor_type hr_organization_information.org_information3%TYPE;
8085: l_branch_or_division hr_organization_information.org_information7%TYPE;
8086: l_org_location hr_organization_units.location_id%TYPE;
8087: l_pan_number hr_organization_information.org_information3%TYPE;
8088: l_legal_name hr_organization_information.org_information4%TYPE;
8089: l_rep_name per_all_people_f.full_name%TYPE;

Line 8087: l_pan_number hr_organization_information.org_information3%TYPE;

8083: l_tan_number hr_organization_information.org_information1%TYPE;
8084: l_deductor_type hr_organization_information.org_information3%TYPE;
8085: l_branch_or_division hr_organization_information.org_information7%TYPE;
8086: l_org_location hr_organization_units.location_id%TYPE;
8087: l_pan_number hr_organization_information.org_information3%TYPE;
8088: l_legal_name hr_organization_information.org_information4%TYPE;
8089: l_rep_name per_all_people_f.full_name%TYPE;
8090: l_rep_position per_all_positions.name%TYPE;
8091: l_rep_location hr_organization_units.location_id%TYPE;

Line 8088: l_legal_name hr_organization_information.org_information4%TYPE;

8084: l_deductor_type hr_organization_information.org_information3%TYPE;
8085: l_branch_or_division hr_organization_information.org_information7%TYPE;
8086: l_org_location hr_organization_units.location_id%TYPE;
8087: l_pan_number hr_organization_information.org_information3%TYPE;
8088: l_legal_name hr_organization_information.org_information4%TYPE;
8089: l_rep_name per_all_people_f.full_name%TYPE;
8090: l_rep_position per_all_positions.name%TYPE;
8091: l_rep_location hr_organization_units.location_id%TYPE;
8092: l_rep_email_id per_all_people_f.email_address%TYPE;

Line 8285: FROM hr_organization_information

8281: CURSOR c_pay_act_id_last_24Q
8282: IS
8283: SELECT org_information3 -- payroll action id of this quarter Form 24Q A/C Archival
8284: ,org_information6 -- Archival Type (Original or Correction Statement)
8285: FROM hr_organization_information
8286: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
8287: AND organization_id = g_gre_id
8288: AND org_information1 = g_year
8289: AND org_information2 = g_quarter

Line 8321: FROM hr_organization_information

8317:
8318: CURSOR c_select_prev_24qc(p_locked_pay_act_id_qc NUMBER)
8319: IS
8320: SELECT MAX(org_information3)
8321: FROM hr_organization_information
8322: WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
8323: AND organization_id = g_gre_id
8324: AND org_information1 = g_year
8325: AND org_information2 = g_quarter

Line 9455: ( challan_no hr_organization_information.org_information1%TYPE

9451: AND pai.action_information1 = p_challan_number
9452: AND paa.payroll_action_id = p_24q_pay_action_id;
9453:
9454: TYPE t_challan_data IS RECORD
9455: ( challan_no hr_organization_information.org_information1%TYPE
9456: ,correction_type VARCHAR2(100)
9457: ,action_information_id NUMBER
9458: ,object_version_number NUMBER
9459: );