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

Line 329: l_classification HR_ORGANIZATION_INFORMATION.ORG_INFORMATION3%TYPE ;

325: l_term_date DATE ;
326: l_report PER_PERIODS_OF_SERVICE.PDS_INFORMATION1%TYPE;
327: l_efile PER_PERIODS_OF_SERVICE.PDS_INFORMATION2%TYPE;
328: l_eps HR_SOFT_CODING_KEYFLEX.SEGMENT12%TYPE;
329: l_classification HR_ORGANIZATION_INFORMATION.ORG_INFORMATION3%TYPE ;
330:
331: CURSOR csr_pf_people IS
332: SELECT
333: ppf.per_information8 pf_no, -- PF Number

Line 361: FROM hr_organization_information hr_pf_org

357:
358: CURSOR csr_pf_classification
359: IS
360: SELECT org_information3 classification
361: FROM hr_organization_information hr_pf_org
362: WHERE org_information_context = 'PER_IN_PF_DF'
363: AND hr_pf_org.organization_id = p_pf_org ;
364:
365: BEGIN

Line 468: l_classification HR_ORGANIZATION_INFORMATION.ORG_INFORMATION3%TYPE ;

464:
465: l_value NUMBER;
466: l_procedure VARCHAR2(100);
467: l_message VARCHAR2(255);
468: l_classification HR_ORGANIZATION_INFORMATION.ORG_INFORMATION3%TYPE ;
469: l_action_info_id NUMBER ;
470: l_ovn NUMBER ;
471: l_vol_pf_rate NUMBER ;
472: l_pf_org NUMBER ;

Line 550: FROM hr_organization_information hr_pf_org

546:
547: CURSOR csr_pf_classification
548: IS
549: SELECT org_information3 classification
550: FROM hr_organization_information hr_pf_org
551: WHERE org_information_context = 'PER_IN_PF_DF'
552: AND hr_pf_org.organization_id = p_pf_org ;
553:
554:

Line 713: l_classification HR_ORGANIZATION_INFORMATION.ORG_INFORMATION3%TYPE ;

709: l_message VARCHAR2(255);
710: l_action_info_id NUMBER ;
711: l_ovn NUMBER ;
712: l_base_bus_no VARCHAR2(50) ;
713: l_classification HR_ORGANIZATION_INFORMATION.ORG_INFORMATION3%TYPE ;
714: l_reg_comp_name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION4%TYPE ;
715: l_representative HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
716: l_representative_name PER_PEOPLE_F.FIRST_NAME%TYPE;
717: l_representative_desig PER_ALL_POSITIONS.NAME%TYPE;

Line 714: l_reg_comp_name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION4%TYPE ;

710: l_action_info_id NUMBER ;
711: l_ovn NUMBER ;
712: l_base_bus_no VARCHAR2(50) ;
713: l_classification HR_ORGANIZATION_INFORMATION.ORG_INFORMATION3%TYPE ;
714: l_reg_comp_name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION4%TYPE ;
715: l_representative HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
716: l_representative_name PER_PEOPLE_F.FIRST_NAME%TYPE;
717: l_representative_desig PER_ALL_POSITIONS.NAME%TYPE;
718: l_bus_group_id VARCHAR2(20);

Line 715: l_representative HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

711: l_ovn NUMBER ;
712: l_base_bus_no VARCHAR2(50) ;
713: l_classification HR_ORGANIZATION_INFORMATION.ORG_INFORMATION3%TYPE ;
714: l_reg_comp_name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION4%TYPE ;
715: l_representative HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
716: l_representative_name PER_PEOPLE_F.FIRST_NAME%TYPE;
717: l_representative_desig PER_ALL_POSITIONS.NAME%TYPE;
718: l_bus_group_id VARCHAR2(20);
719:

Line 728: FROM hr_organization_information hr_pf_org

724: organization_id org_id , --OrgId
725: org_information10 base_bus_no, --Base Business Number
726: org_information10||org_information9 bus_no , --Business Number
727: org_information3 classification --Classification
728: FROM hr_organization_information hr_pf_org
729: WHERE org_information_context = 'PER_IN_PF_DF'
730: AND hr_pf_org.org_information10||org_information9 = p_business_number ;
731:
732:

Line 736: FROM hr_organization_information

732:
733: CURSOR csr_reg_company(p_base_bus_no VARCHAR2 )
734: IS
735: SELECT org_information4 --Legal Name
736: FROM hr_organization_information
737: WHERE org_information_context = 'PER_IN_COMPANY_DF'
738: AND org_information5 = p_base_bus_no ;
739:
740: CURSOR csr_pf_representative(p_pf_org NUMBER )

Line 744: FROM hr_organization_information hr_pf_org

740: CURSOR csr_pf_representative(p_pf_org NUMBER )
741: IS
742: SELECT
743: org_information1 --Representative
744: FROM hr_organization_information hr_pf_org
745: WHERE org_information_context = 'PER_IN_PF_REP_DF'
746: AND hr_pf_org.organization_id = p_pf_org
747: AND g_end_date BETWEEN fnd_date.canonical_to_date(org_information2)
748: AND NVL(fnd_date.canonical_to_date(org_information3),TO_DATE('31-12-4712','DD-MM-YYYY'));

Line 902: l_Paid_Under_Protest HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

898: l_message VARCHAR2(255);
899: l_action_info_id NUMBER ;
900: l_ovn NUMBER ;
901:
902: l_Paid_Under_Protest HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
903: l_Payment_Type HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
904: l_Cheque_DD_No HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
905: l_Cheque_DD_Date DATE ;
906: l_Cheque_DD_Dep_Date DATE ;

Line 903: l_Payment_Type HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

899: l_action_info_id NUMBER ;
900: l_ovn NUMBER ;
901:
902: l_Paid_Under_Protest HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
903: l_Payment_Type HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
904: l_Cheque_DD_No HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
905: l_Cheque_DD_Date DATE ;
906: l_Cheque_DD_Dep_Date DATE ;
907: l_Amount HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 904: l_Cheque_DD_No HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

900: l_ovn NUMBER ;
901:
902: l_Paid_Under_Protest HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
903: l_Payment_Type HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
904: l_Cheque_DD_No HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
905: l_Cheque_DD_Date DATE ;
906: l_Cheque_DD_Dep_Date DATE ;
907: l_Amount HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
908: l_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 907: l_Amount HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

903: l_Payment_Type HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
904: l_Cheque_DD_No HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
905: l_Cheque_DD_Date DATE ;
906: l_Cheque_DD_Dep_Date DATE ;
907: l_Amount HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
908: l_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
909: l_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
910: l_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
911: l_Dep_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 908: l_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

904: l_Cheque_DD_No HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
905: l_Cheque_DD_Date DATE ;
906: l_Cheque_DD_Dep_Date DATE ;
907: l_Amount HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
908: l_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
909: l_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
910: l_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
911: l_Dep_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
912: l_Dep_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 909: l_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

905: l_Cheque_DD_Date DATE ;
906: l_Cheque_DD_Dep_Date DATE ;
907: l_Amount HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
908: l_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
909: l_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
910: l_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
911: l_Dep_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
912: l_Dep_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
913: l_Dep_Base_Branch HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 910: l_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

906: l_Cheque_DD_Dep_Date DATE ;
907: l_Amount HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
908: l_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
909: l_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
910: l_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
911: l_Dep_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
912: l_Dep_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
913: l_Dep_Base_Branch HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
914: l_Interest_Sec HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 911: l_Dep_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

907: l_Amount HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
908: l_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
909: l_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
910: l_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
911: l_Dep_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
912: l_Dep_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
913: l_Dep_Base_Branch HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
914: l_Interest_Sec HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
915: l_Legal_Charges HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 912: l_Dep_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

908: l_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
909: l_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
910: l_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
911: l_Dep_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
912: l_Dep_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
913: l_Dep_Base_Branch HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
914: l_Interest_Sec HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
915: l_Legal_Charges HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
916: l_Penalty HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 913: l_Dep_Base_Branch HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

909: l_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
910: l_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
911: l_Dep_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
912: l_Dep_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
913: l_Dep_Base_Branch HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
914: l_Interest_Sec HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
915: l_Legal_Charges HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
916: l_Penalty HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
917: l_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 914: l_Interest_Sec HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

910: l_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
911: l_Dep_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
912: l_Dep_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
913: l_Dep_Base_Branch HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
914: l_Interest_Sec HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
915: l_Legal_Charges HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
916: l_Penalty HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
917: l_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
918: l_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 915: l_Legal_Charges HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

911: l_Dep_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
912: l_Dep_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
913: l_Dep_Base_Branch HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
914: l_Interest_Sec HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
915: l_Legal_Charges HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
916: l_Penalty HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
917: l_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
918: l_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
919: l_Dep_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 916: l_Penalty HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

912: l_Dep_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
913: l_Dep_Base_Branch HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
914: l_Interest_Sec HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
915: l_Legal_Charges HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
916: l_Penalty HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
917: l_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
918: l_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
919: l_Dep_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
920: l_Dep_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 917: l_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

913: l_Dep_Base_Branch HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
914: l_Interest_Sec HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
915: l_Legal_Charges HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
916: l_Penalty HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
917: l_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
918: l_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
919: l_Dep_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
920: l_Dep_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
921:

Line 918: l_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

914: l_Interest_Sec HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
915: l_Legal_Charges HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
916: l_Penalty HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
917: l_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
918: l_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
919: l_Dep_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
920: l_Dep_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
921:
922: l_14B_Prev_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 919: l_Dep_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

915: l_Legal_Charges HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
916: l_Penalty HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
917: l_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
918: l_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
919: l_Dep_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
920: l_Dep_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
921:
922: l_14B_Prev_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
923: l_14B_Prev_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 920: l_Dep_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

916: l_Penalty HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
917: l_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
918: l_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
919: l_Dep_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
920: l_Dep_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
921:
922: l_14B_Prev_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
923: l_14B_Prev_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
924: l_14B_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 922: l_14B_Prev_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

918: l_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
919: l_Dep_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
920: l_Dep_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
921:
922: l_14B_Prev_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
923: l_14B_Prev_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
924: l_14B_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
925: l_14B_Penal_Damages_Due HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
926: l_14B_EPS_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 923: l_14B_Prev_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

919: l_Dep_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
920: l_Dep_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
921:
922: l_14B_Prev_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
923: l_14B_Prev_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
924: l_14B_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
925: l_14B_Penal_Damages_Due HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
926: l_14B_EPS_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
927: l_14B_EDLI_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 924: l_14B_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

920: l_Dep_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
921:
922: l_14B_Prev_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
923: l_14B_Prev_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
924: l_14B_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
925: l_14B_Penal_Damages_Due HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
926: l_14B_EPS_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
927: l_14B_EDLI_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
928: l_14B_EPF_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 925: l_14B_Penal_Damages_Due HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

921:
922: l_14B_Prev_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
923: l_14B_Prev_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
924: l_14B_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
925: l_14B_Penal_Damages_Due HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
926: l_14B_EPS_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
927: l_14B_EDLI_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
928: l_14B_EPF_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
929: l_14B_Edli_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 926: l_14B_EPS_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

922: l_14B_Prev_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
923: l_14B_Prev_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
924: l_14B_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
925: l_14B_Penal_Damages_Due HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
926: l_14B_EPS_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
927: l_14B_EDLI_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
928: l_14B_EPF_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
929: l_14B_Edli_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
930:

Line 927: l_14B_EDLI_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

923: l_14B_Prev_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
924: l_14B_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
925: l_14B_Penal_Damages_Due HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
926: l_14B_EPS_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
927: l_14B_EDLI_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
928: l_14B_EPF_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
929: l_14B_Edli_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
930:
931: l_7Q_Due_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

Line 928: l_14B_EPF_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

924: l_14B_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
925: l_14B_Penal_Damages_Due HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
926: l_14B_EPS_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
927: l_14B_EDLI_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
928: l_14B_EPF_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
929: l_14B_Edli_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
930:
931: l_7Q_Due_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
932: l_7Q_Due_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 929: l_14B_Edli_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

925: l_14B_Penal_Damages_Due HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
926: l_14B_EPS_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
927: l_14B_EDLI_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
928: l_14B_EPF_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
929: l_14B_Edli_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
930:
931: l_7Q_Due_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
932: l_7Q_Due_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
933: l_7Q_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 931: l_7Q_Due_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

927: l_14B_EDLI_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
928: l_14B_EPF_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
929: l_14B_Edli_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
930:
931: l_7Q_Due_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
932: l_7Q_Due_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
933: l_7Q_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
934: l_7Q_EPF_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
935: l_7Q_EPS_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 932: l_7Q_Due_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

928: l_14B_EPF_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
929: l_14B_Edli_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
930:
931: l_7Q_Due_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
932: l_7Q_Due_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
933: l_7Q_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
934: l_7Q_EPF_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
935: l_7Q_EPS_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
936: l_7Q_EDLI_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 933: l_7Q_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

929: l_14B_Edli_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
930:
931: l_7Q_Due_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
932: l_7Q_Due_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
933: l_7Q_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
934: l_7Q_EPF_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
935: l_7Q_EPS_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
936: l_7Q_EDLI_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
937: l_7Q_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 934: l_7Q_EPF_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

930:
931: l_7Q_Due_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
932: l_7Q_Due_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
933: l_7Q_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
934: l_7Q_EPF_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
935: l_7Q_EPS_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
936: l_7Q_EDLI_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
937: l_7Q_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
938: l_7Q_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

Line 935: l_7Q_EPS_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

931: l_7Q_Due_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
932: l_7Q_Due_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
933: l_7Q_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
934: l_7Q_EPF_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
935: l_7Q_EPS_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
936: l_7Q_EDLI_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
937: l_7Q_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
938: l_7Q_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
939:

Line 936: l_7Q_EDLI_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

932: l_7Q_Due_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
933: l_7Q_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
934: l_7Q_EPF_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
935: l_7Q_EPS_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
936: l_7Q_EDLI_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
937: l_7Q_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
938: l_7Q_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
939:
940: l_Misc_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 937: l_7Q_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

933: l_7Q_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
934: l_7Q_EPF_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
935: l_7Q_EPS_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
936: l_7Q_EDLI_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
937: l_7Q_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
938: l_7Q_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
939:
940: l_Misc_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
941: l_Misc_EPF_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

Line 938: l_7Q_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

934: l_7Q_EPF_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
935: l_7Q_EPS_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
936: l_7Q_EDLI_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
937: l_7Q_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
938: l_7Q_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
939:
940: l_Misc_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
941: l_Misc_EPF_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
942: l_Misc_EPF_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

Line 940: l_Misc_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

936: l_7Q_EDLI_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
937: l_7Q_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
938: l_7Q_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
939:
940: l_Misc_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
941: l_Misc_EPF_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
942: l_Misc_EPF_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
943: l_Misc_EPS_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
944: l_Misc_EPS_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

Line 941: l_Misc_EPF_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

937: l_7Q_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
938: l_7Q_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
939:
940: l_Misc_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
941: l_Misc_EPF_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
942: l_Misc_EPF_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
943: l_Misc_EPS_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
944: l_Misc_EPS_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
945: l_Misc_EDLI_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

Line 942: l_Misc_EPF_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

938: l_7Q_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
939:
940: l_Misc_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
941: l_Misc_EPF_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
942: l_Misc_EPF_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
943: l_Misc_EPS_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
944: l_Misc_EPS_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
945: l_Misc_EDLI_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
946: l_Misc_EDLI_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

Line 943: l_Misc_EPS_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

939:
940: l_Misc_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
941: l_Misc_EPF_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
942: l_Misc_EPF_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
943: l_Misc_EPS_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
944: l_Misc_EPS_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
945: l_Misc_EDLI_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
946: l_Misc_EDLI_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
947: l_Misc_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

Line 944: l_Misc_EPS_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

940: l_Misc_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
941: l_Misc_EPF_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
942: l_Misc_EPF_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
943: l_Misc_EPS_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
944: l_Misc_EPS_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
945: l_Misc_EDLI_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
946: l_Misc_EDLI_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
947: l_Misc_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
948: l_Misc_EPF_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

Line 945: l_Misc_EDLI_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

941: l_Misc_EPF_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
942: l_Misc_EPF_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
943: l_Misc_EPS_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
944: l_Misc_EPS_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
945: l_Misc_EDLI_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
946: l_Misc_EDLI_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
947: l_Misc_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
948: l_Misc_EPF_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
949: l_Misc_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

Line 946: l_Misc_EDLI_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

942: l_Misc_EPF_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
943: l_Misc_EPS_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
944: l_Misc_EPS_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
945: l_Misc_EDLI_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
946: l_Misc_EDLI_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
947: l_Misc_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
948: l_Misc_EPF_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
949: l_Misc_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
950: l_Misc_EDLI_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

Line 947: l_Misc_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

943: l_Misc_EPS_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
944: l_Misc_EPS_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
945: l_Misc_EDLI_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
946: l_Misc_EDLI_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
947: l_Misc_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
948: l_Misc_EPF_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
949: l_Misc_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
950: l_Misc_EDLI_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
951:

Line 948: l_Misc_EPF_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

944: l_Misc_EPS_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
945: l_Misc_EDLI_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
946: l_Misc_EDLI_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
947: l_Misc_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
948: l_Misc_EPF_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
949: l_Misc_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
950: l_Misc_EDLI_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
951:
952:

Line 949: l_Misc_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

945: l_Misc_EDLI_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
946: l_Misc_EDLI_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
947: l_Misc_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
948: l_Misc_EPF_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
949: l_Misc_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
950: l_Misc_EDLI_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
951:
952:
953:

Line 950: l_Misc_EDLI_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

946: l_Misc_EDLI_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
947: l_Misc_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
948: l_Misc_EPF_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
949: l_Misc_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
950: l_Misc_EDLI_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
951:
952:
953:
954:

Line 965: FROM hr_organization_information hoi_challan

961: ,hoi_challan.org_information8 Branch_Code
962: ,hoi_challan.org_information11 Dep_Bank_Code
963: ,hoi_challan.org_information9 Dep_Branch_Code
964: ,hoi_challan.org_information10 Dep_Base_Branch
965: FROM hr_organization_information hoi_challan
966: WHERE hoi_challan.organization_id = p_pf_org
967: AND hoi_challan.org_information_context ='PER_IN_PF_BANK_PAYMENT_DETAILS'
968: AND hoi_challan.org_information3= p_challan_ref;
969:

Line 988: FROM hr_organization_information hoi_challan

984: ,hoi_challan.org_information12 Challan_Ref
985: ,hoi_challan.org_information13 Legal_Charges
986: ,hoi_challan.org_information14 Interest_Sec
987: ,hoi_challan.org_information15 Penalty
988: FROM hr_organization_information hoi_challan
989: WHERE hoi_challan.organization_id = p_pf_org
990: AND hoi_challan.org_information_context ='PER_IN_PF_CHALLAN_INFO'
991: AND hoi_challan.org_information12= p_challan_ref;
992:

Line 1004: FROM hr_organization_information hoi_challan

1000: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EPS_Penal_Damages
1001: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Penal_Damages
1002: ,fnd_number.canonical_to_number(hoi_challan.org_information9) EPF_Penal_Damages
1003: ,fnd_number.canonical_to_number(hoi_challan.org_information8) Edli_Admin
1004: FROM hr_organization_information hoi_challan
1005: WHERE hoi_challan.organization_id = p_pf_org
1006: AND hoi_challan.org_information_context ='PER_IN_PF_CHN_SEC14B'
1007: AND hoi_challan.org_information1= p_challan_ref;
1008:

Line 1020: FROM hr_organization_information hoi_challan

1016: ,fnd_number.canonical_to_number(hoi_challan.org_information5) EPS_Damages
1017: ,fnd_number.canonical_to_number(hoi_challan.org_information6) EDLI_Damages
1018: ,fnd_number.canonical_to_number(hoi_challan.org_information8) EPF_Admin
1019: ,fnd_number.canonical_to_number(hoi_challan.org_information7) EDLI_Admin
1020: FROM hr_organization_information hoi_challan
1021: WHERE hoi_challan.organization_id = p_pf_org
1022: AND hoi_challan.org_information_context ='PER_IN_PF_SEC7Q_INFO'
1023: AND hoi_challan.org_information11= p_challan_ref;
1024:

Line 1039: FROM hr_organization_information hoi_challan

1035: ,fnd_number.canonical_to_number(hoi_challan.org_information11) EPF_Admin
1036: ,hoi_challan.org_information12 EPF_Admin_Rem
1037: ,fnd_number.canonical_to_number(hoi_challan.org_information13) EDLI_Admin
1038: ,hoi_challan.org_information14 EDLI_Admin_Rem
1039: FROM hr_organization_information hoi_challan
1040: WHERE hoi_challan.organization_id = p_pf_org
1041: AND hoi_challan.org_information_context ='PER_IN_PF_MIS_PAY_INFO'
1042: AND hoi_challan.org_information3= p_challan_ref;
1043:

Line 1051: ,hr_organization_information hoi

1047: IS
1048: SELECT hoi.org_information3 branch_name
1049: ,hoi.org_information4 branch_add
1050: FROM hr_organization_units hou
1051: ,hr_organization_information hoi
1052: WHERE hoi.organization_id = hou.organization_id
1053: AND hoi.org_information_context = 'PER_IN_PF_BANK_BRANCH_DTLS'
1054: AND hou.business_group_id = g_bg_id
1055: AND hoi.org_information1 = p_bank_code

Line 1348: hr_organization_information hoi

1344: SELECT DISTINCT paa_init.assignment_id
1345: FROM pay_assignment_actions paa_init,
1346: pay_payroll_actions ppa_init,
1347: per_assignments_f paf,
1348: hr_organization_information hoi
1349: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id
1350: AND ppa_init.action_type IN ('P','U','I')
1351: AND ppa_init.action_status = 'C'
1352: AND ppa_init.business_group_id = g_bg_id

Line 1384: hr_organization_information hoi

1380: SELECT DISTINCT paa_init.assignment_id
1381: FROM pay_assignment_actions paa_init,
1382: pay_payroll_actions ppa_init,
1383: per_assignments_f paf,
1384: hr_organization_information hoi
1385: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id
1386: AND ppa_init.action_type IN ('P','U','I')
1387: AND ppa_init.action_status = 'C'
1388: AND ppa_init.business_group_id = g_bg_id

Line 1409: ,hr_organization_information hoi

1405: AND scl.enabled_flag = 'Y')
1406: AND NOT EXISTS ( SELECT paa.assignment_id
1407: FROM pay_assignment_actions paa
1408: ,pay_action_information pai
1409: ,hr_organization_information hoi
1410: ,pay_payroll_actions ppa
1411: WHERE paa.assignment_id = paa_init.assignment_id
1412: AND paa.assignment_action_id = pai.action_context_id
1413: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1431: hr_organization_information hoi

1427: FROM pay_assignment_actions paa_init,
1428: per_periods_of_service pps,
1429: pay_payroll_actions ppa_init,
1430: per_assignments_f paf,
1431: hr_organization_information hoi
1432: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id
1433: AND paf.period_of_service_id = pps.period_of_service_id
1434: AND ppa_init.action_type IN ('P','U','I')
1435: AND ppa_init.action_status = 'C'

Line 1458: ,hr_organization_information hoi

1454: AND scl.enabled_flag = 'Y')
1455: AND NOT EXISTS ( SELECT paa.assignment_id
1456: FROM pay_assignment_actions paa
1457: ,pay_action_information pai
1458: ,hr_organization_information hoi
1459: ,hr_organization_units hou
1460: ,pay_payroll_actions ppa
1461: WHERE paa.assignment_id = paa_init.assignment_id
1462: AND paa.assignment_action_id = pai.action_context_id

Line 1490: hr_organization_information hoi

1486: SELECT DISTINCT paa_init.assignment_id
1487: FROM pay_assignment_actions paa_init,
1488: pay_payroll_actions ppa_init,
1489: per_assignments_f paf,
1490: hr_organization_information hoi
1491: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id
1492: AND ppa_init.action_type IN ('P','U','I')
1493: AND ppa_init.action_status = 'C'
1494: AND ppa_init.business_group_id = g_bg_id

Line 1524: FROM hr_organization_information hoi_challan

1520: ,p_business_no NUMBER )
1521: IS
1522: SELECT
1523: hoi_challan.org_information12 Challan_Ref
1524: FROM hr_organization_information hoi_challan
1525: WHERE hoi_challan.organization_id = p_pf_org
1526: AND hoi_challan.org_information_context ='PER_IN_PF_CHALLAN_INFO'
1527: AND hoi_challan.org_information1 = g_challan_year
1528: AND hoi_challan.org_information2 = g_challan_mth

Line 1544: FROM hr_organization_information hoi ,

1540: AND pai.action_context_id IN
1541: (SELECT action_context_id
1542: FROM pay_action_information painfo
1543: WHERE painfo.action_information2 IN (SELECT hoi.org_information7
1544: FROM hr_organization_information hoi ,
1545: hr_organization_units hou
1546: WHERE hoi.organization_id = hou.organization_id
1547: AND hoi.org_information_context = 'PER_IN_COMPANY_RECEP_MAP'
1548: AND hoi.org_information3 = p_business_no

Line 1561: FROM hr_organization_information hoi_challan

1557: CURSOR csr_revised_challans(p_pf_org NUMBER)
1558: IS
1559: SELECT
1560: hoi_challan.org_information12 Challan_Ref
1561: FROM hr_organization_information hoi_challan
1562: WHERE hoi_challan.organization_id = p_pf_org
1563: AND hoi_challan.org_information_context ='PER_IN_PF_CHALLAN_INFO'
1564: AND hoi_challan.org_information1 = g_challan_year
1565: AND hoi_challan.org_information2 = g_challan_mth ;

Line 1576: FROM hr_organization_information

1572: */
1573: CURSOR csr_reg_return
1574: IS
1575: SELECT org_information3 bus_no
1576: FROM hr_organization_information
1577: WHERE org_information_context = 'PER_IN_COMPANY_RECEP_MAP'
1578: AND org_information1 = g_challan_year
1579: AND org_information2 = g_challan_mth
1580: AND org_information3 = NVL(g_business_no , org_information3)

Line 1587: FROM hr_organization_information

1583:
1584: CURSOR csr_arch_ref(p_business_no IN NUMBER)
1585: IS
1586: SELECT DISTINCT org_information7 Archive_Ref_No
1587: FROM hr_organization_information
1588: WHERE org_information_context = 'PER_IN_COMPANY_RECEP_MAP'
1589: AND org_information1 = g_challan_year
1590: AND org_information2 = g_challan_mth
1591: AND org_information3 = NVL(p_business_no,org_information3) ;

Line 1618: FROM hr_organization_information hr_pf_org

1614:
1615: CURSOR csr_pf_org_id(p_business_no IN NUMBER)
1616: IS
1617: SELECT hr_pf_org.organization_id pf_org --PF Org Id
1618: FROM hr_organization_information hr_pf_org
1619: WHERE org_information_context = 'PER_IN_PF_DF'
1620: AND org_information10||org_information9 = p_business_no ;
1621:
1622:

Line 1940: FROM hr_organization_information hr_pf_org

1936: IS
1937: SELECT hr_pf_org.organization_id pf_org,
1938: org_information10 base_bus_no,
1939: org_information10||org_information9 business_number
1940: FROM hr_organization_information hr_pf_org
1941: ,hr_organization_units hou
1942: WHERE hou.organization_id = hr_pf_org.organization_id
1943: AND hou.business_group_id = g_bg_id
1944: AND org_information_context = 'PER_IN_PF_DF'

Line 1955: FROM hr_organization_information hoi_challan

1951: CURSOR csr_challans(p_pf_org VARCHAR2 )
1952: IS
1953: SELECT
1954: hoi_challan.org_information12 Challan_Ref
1955: FROM hr_organization_information hoi_challan
1956: WHERE hoi_challan.organization_id = p_pf_org
1957: AND hoi_challan.org_information_context ='PER_IN_PF_CHALLAN_INFO'
1958: AND hoi_challan.org_information1 = g_challan_year
1959: AND hoi_challan.org_information2 = g_challan_mth ;