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 331: l_classification HR_ORGANIZATION_INFORMATION.ORG_INFORMATION3%TYPE ;

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

Line 365: FROM hr_organization_information hr_pf_org

361:
362: CURSOR csr_pf_classification
363: IS
364: SELECT org_information3 classification
365: FROM hr_organization_information hr_pf_org
366: WHERE org_information_context = 'PER_IN_PF_DF'
367: AND hr_pf_org.organization_id = p_pf_org ;
368:
369: BEGIN

Line 472: l_classification HR_ORGANIZATION_INFORMATION.ORG_INFORMATION3%TYPE ;

468:
469: l_value NUMBER;
470: l_procedure VARCHAR2(100);
471: l_message VARCHAR2(255);
472: l_classification HR_ORGANIZATION_INFORMATION.ORG_INFORMATION3%TYPE ;
473: l_action_info_id NUMBER ;
474: l_ovn NUMBER ;
475: l_vol_pf_rate NUMBER ;
476: l_pf_org NUMBER ;

Line 554: FROM hr_organization_information hr_pf_org

550:
551: CURSOR csr_pf_classification
552: IS
553: SELECT org_information3 classification
554: FROM hr_organization_information hr_pf_org
555: WHERE org_information_context = 'PER_IN_PF_DF'
556: AND hr_pf_org.organization_id = p_pf_org ;
557:
558:

Line 717: l_classification HR_ORGANIZATION_INFORMATION.ORG_INFORMATION3%TYPE ;

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

Line 718: l_reg_comp_name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION4%TYPE ;

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

Line 719: l_representative HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

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

Line 732: FROM hr_organization_information hr_pf_org

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

Line 740: FROM hr_organization_information

736:
737: CURSOR csr_reg_company(p_base_bus_no VARCHAR2 )
738: IS
739: SELECT org_information4 --Legal Name
740: FROM hr_organization_information
741: WHERE org_information_context = 'PER_IN_COMPANY_DF'
742: AND org_information5 = p_base_bus_no ;
743:
744: CURSOR csr_pf_representative(p_pf_org NUMBER )

Line 748: FROM hr_organization_information hr_pf_org

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

Line 906: l_Paid_Under_Protest HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

902: l_message VARCHAR2(255);
903: l_action_info_id NUMBER ;
904: l_ovn NUMBER ;
905:
906: l_Paid_Under_Protest HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
907: l_Payment_Type HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
908: l_Cheque_DD_No HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
909: l_Cheque_DD_Date DATE ;
910: l_Cheque_DD_Dep_Date DATE ;

Line 907: l_Payment_Type HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

903: l_action_info_id NUMBER ;
904: l_ovn NUMBER ;
905:
906: l_Paid_Under_Protest HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
907: l_Payment_Type HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
908: l_Cheque_DD_No HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
909: l_Cheque_DD_Date DATE ;
910: l_Cheque_DD_Dep_Date DATE ;
911: l_Amount HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 908: l_Cheque_DD_No HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

904: l_ovn NUMBER ;
905:
906: l_Paid_Under_Protest HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
907: l_Payment_Type HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
908: l_Cheque_DD_No HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
909: l_Cheque_DD_Date DATE ;
910: l_Cheque_DD_Dep_Date DATE ;
911: l_Amount HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
912: l_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 911: l_Amount HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

907: l_Payment_Type HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
908: l_Cheque_DD_No HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
909: l_Cheque_DD_Date DATE ;
910: l_Cheque_DD_Dep_Date DATE ;
911: l_Amount HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
912: l_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
913: l_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
914: l_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
915: l_Dep_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 912: l_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

908: l_Cheque_DD_No HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
909: l_Cheque_DD_Date DATE ;
910: l_Cheque_DD_Dep_Date DATE ;
911: l_Amount HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
912: l_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
913: l_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
914: l_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
915: l_Dep_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
916: l_Dep_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 913: l_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

909: l_Cheque_DD_Date DATE ;
910: l_Cheque_DD_Dep_Date DATE ;
911: l_Amount HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
912: l_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
913: l_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
914: l_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
915: l_Dep_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
916: l_Dep_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
917: l_Dep_Base_Branch HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 914: l_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

910: l_Cheque_DD_Dep_Date DATE ;
911: l_Amount HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
912: l_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
913: l_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
914: l_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
915: l_Dep_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
916: l_Dep_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
917: l_Dep_Base_Branch HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
918: l_Interest_Sec HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 915: l_Dep_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

911: l_Amount HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
912: l_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
913: l_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
914: l_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
915: l_Dep_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
916: l_Dep_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
917: l_Dep_Base_Branch HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
918: l_Interest_Sec HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
919: l_Legal_Charges HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 916: l_Dep_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

912: l_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
913: l_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
914: l_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
915: l_Dep_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
916: l_Dep_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
917: l_Dep_Base_Branch HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
918: l_Interest_Sec HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
919: l_Legal_Charges HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
920: l_Penalty HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 917: l_Dep_Base_Branch HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

913: l_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
914: l_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
915: l_Dep_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
916: l_Dep_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
917: l_Dep_Base_Branch HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
918: l_Interest_Sec HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
919: l_Legal_Charges HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
920: l_Penalty HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
921: l_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 918: l_Interest_Sec HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

914: l_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
915: l_Dep_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
916: l_Dep_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
917: l_Dep_Base_Branch HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
918: l_Interest_Sec HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
919: l_Legal_Charges HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
920: l_Penalty HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
921: l_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
922: l_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 919: l_Legal_Charges HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

915: l_Dep_Bank_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
916: l_Dep_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
917: l_Dep_Base_Branch HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
918: l_Interest_Sec HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
919: l_Legal_Charges HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
920: l_Penalty HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
921: l_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
922: l_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
923: l_Dep_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 920: l_Penalty HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

916: l_Dep_Branch_Code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
917: l_Dep_Base_Branch HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
918: l_Interest_Sec HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
919: l_Legal_Charges HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
920: l_Penalty HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
921: l_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
922: l_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
923: l_Dep_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
924: l_Dep_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 921: l_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

917: l_Dep_Base_Branch HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
918: l_Interest_Sec HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
919: l_Legal_Charges HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
920: l_Penalty HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
921: l_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
922: l_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
923: l_Dep_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
924: l_Dep_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
925:

Line 922: l_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

918: l_Interest_Sec HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
919: l_Legal_Charges HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
920: l_Penalty HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
921: l_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
922: l_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
923: l_Dep_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
924: l_Dep_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
925:
926: l_14B_Prev_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 923: l_Dep_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

919: l_Legal_Charges HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
920: l_Penalty HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
921: l_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
922: l_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
923: l_Dep_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
924: l_Dep_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
925:
926: l_14B_Prev_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
927: l_14B_Prev_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 924: l_Dep_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

920: l_Penalty HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
921: l_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
922: l_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
923: l_Dep_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
924: l_Dep_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
925:
926: l_14B_Prev_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
927: l_14B_Prev_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
928: l_14B_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 926: l_14B_Prev_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

922: l_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
923: l_Dep_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
924: l_Dep_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
925:
926: l_14B_Prev_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
927: l_14B_Prev_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
928: l_14B_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
929: l_14B_Penal_Damages_Due HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
930: l_14B_EPS_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 927: l_14B_Prev_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

923: l_Dep_Branch_Name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
924: l_Dep_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
925:
926: l_14B_Prev_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
927: l_14B_Prev_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
928: l_14B_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
929: l_14B_Penal_Damages_Due HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
930: l_14B_EPS_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
931: l_14B_EDLI_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 928: l_14B_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

924: l_Dep_Branch_Addr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
925:
926: l_14B_Prev_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
927: l_14B_Prev_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
928: l_14B_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
929: l_14B_Penal_Damages_Due HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
930: l_14B_EPS_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
931: l_14B_EDLI_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
932: l_14B_EPF_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 929: l_14B_Penal_Damages_Due HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

925:
926: l_14B_Prev_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
927: l_14B_Prev_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
928: l_14B_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
929: l_14B_Penal_Damages_Due HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
930: l_14B_EPS_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
931: l_14B_EDLI_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
932: l_14B_EPF_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
933: l_14B_Edli_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 930: l_14B_EPS_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

926: l_14B_Prev_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
927: l_14B_Prev_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
928: l_14B_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
929: l_14B_Penal_Damages_Due HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
930: l_14B_EPS_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
931: l_14B_EDLI_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
932: l_14B_EPF_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
933: l_14B_Edli_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
934:

Line 931: l_14B_EDLI_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

927: l_14B_Prev_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
928: l_14B_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
929: l_14B_Penal_Damages_Due HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
930: l_14B_EPS_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
931: l_14B_EDLI_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
932: l_14B_EPF_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
933: l_14B_Edli_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
934:
935: l_7Q_Due_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

Line 932: l_14B_EPF_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

928: l_14B_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
929: l_14B_Penal_Damages_Due HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
930: l_14B_EPS_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
931: l_14B_EDLI_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
932: l_14B_EPF_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
933: l_14B_Edli_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
934:
935: l_7Q_Due_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
936: l_7Q_Due_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 933: l_14B_Edli_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

929: l_14B_Penal_Damages_Due HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
930: l_14B_EPS_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
931: l_14B_EDLI_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
932: l_14B_EPF_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
933: l_14B_Edli_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
934:
935: l_7Q_Due_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
936: l_7Q_Due_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
937: l_7Q_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 935: l_7Q_Due_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

931: l_14B_EDLI_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
932: l_14B_EPF_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
933: l_14B_Edli_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
934:
935: l_7Q_Due_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
936: l_7Q_Due_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
937: l_7Q_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
938: l_7Q_EPF_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
939: l_7Q_EPS_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 936: l_7Q_Due_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

932: l_14B_EPF_Penal_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
933: l_14B_Edli_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
934:
935: l_7Q_Due_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
936: l_7Q_Due_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
937: l_7Q_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
938: l_7Q_EPF_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
939: l_7Q_EPS_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
940: l_7Q_EDLI_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 937: l_7Q_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

933: l_14B_Edli_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
934:
935: l_7Q_Due_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
936: l_7Q_Due_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
937: l_7Q_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
938: l_7Q_EPF_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
939: l_7Q_EPS_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
940: l_7Q_EDLI_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
941: l_7Q_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 938: l_7Q_EPF_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

934:
935: l_7Q_Due_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
936: l_7Q_Due_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
937: l_7Q_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
938: l_7Q_EPF_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
939: l_7Q_EPS_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
940: l_7Q_EDLI_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
941: l_7Q_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
942: l_7Q_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

Line 939: l_7Q_EPS_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

935: l_7Q_Due_Mth HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
936: l_7Q_Due_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
937: l_7Q_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
938: l_7Q_EPF_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
939: l_7Q_EPS_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
940: l_7Q_EDLI_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
941: l_7Q_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
942: l_7Q_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
943:

Line 940: l_7Q_EDLI_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

936: l_7Q_Due_Yr HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
937: l_7Q_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
938: l_7Q_EPF_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
939: l_7Q_EPS_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
940: l_7Q_EDLI_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
941: l_7Q_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
942: l_7Q_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
943:
944: l_Misc_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

Line 941: l_7Q_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

937: l_7Q_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
938: l_7Q_EPF_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
939: l_7Q_EPS_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
940: l_7Q_EDLI_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
941: l_7Q_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
942: l_7Q_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
943:
944: l_Misc_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
945: l_Misc_EPF_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

Line 942: l_7Q_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

938: l_7Q_EPF_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
939: l_7Q_EPS_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
940: l_7Q_EDLI_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
941: l_7Q_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
942: l_7Q_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
943:
944: l_Misc_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
945: l_Misc_EPF_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
946: l_Misc_EPF_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

Line 944: l_Misc_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;

940: l_7Q_EDLI_Damages HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
941: l_7Q_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
942: l_7Q_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
943:
944: l_Misc_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
945: l_Misc_EPF_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
946: l_Misc_EPF_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
947: l_Misc_EPS_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
948: l_Misc_EPS_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

Line 945: l_Misc_EPF_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

941: l_7Q_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
942: l_7Q_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
943:
944: l_Misc_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
945: l_Misc_EPF_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
946: l_Misc_EPF_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
947: l_Misc_EPS_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
948: l_Misc_EPS_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
949: l_Misc_EDLI_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

Line 946: l_Misc_EPF_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

942: l_7Q_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
943:
944: l_Misc_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
945: l_Misc_EPF_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
946: l_Misc_EPF_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
947: l_Misc_EPS_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
948: l_Misc_EPS_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
949: l_Misc_EDLI_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
950: l_Misc_EDLI_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

Line 947: l_Misc_EPS_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

943:
944: l_Misc_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
945: l_Misc_EPF_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
946: l_Misc_EPF_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
947: l_Misc_EPS_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
948: l_Misc_EPS_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
949: l_Misc_EDLI_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
950: l_Misc_EDLI_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
951: l_Misc_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

Line 948: l_Misc_EPS_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

944: l_Misc_Challan_Ref HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
945: l_Misc_EPF_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
946: l_Misc_EPF_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
947: l_Misc_EPS_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
948: l_Misc_EPS_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
949: l_Misc_EDLI_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
950: l_Misc_EDLI_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
951: l_Misc_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
952: l_Misc_EPF_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

Line 949: l_Misc_EDLI_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

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

Line 950: l_Misc_EDLI_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

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

Line 951: l_Misc_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

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

Line 952: l_Misc_EPF_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

948: l_Misc_EPS_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
949: l_Misc_EDLI_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
950: l_Misc_EDLI_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
951: l_Misc_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
952: l_Misc_EPF_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
953: l_Misc_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
954: l_Misc_EDLI_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
955:
956:

Line 953: l_Misc_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

949: l_Misc_EDLI_Pay HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
950: l_Misc_EDLI_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
951: l_Misc_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
952: l_Misc_EPF_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
953: l_Misc_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
954: l_Misc_EDLI_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
955:
956:
957:

Line 954: l_Misc_EDLI_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;

950: l_Misc_EDLI_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
951: l_Misc_EPF_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
952: l_Misc_EPF_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
953: l_Misc_EDLI_Admin HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
954: l_Misc_EDLI_Admin_Rem HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE ;
955:
956:
957:
958:

Line 969: FROM hr_organization_information hoi_challan

965: ,hoi_challan.org_information8 Branch_Code
966: ,hoi_challan.org_information11 Dep_Bank_Code
967: ,hoi_challan.org_information9 Dep_Branch_Code
968: ,hoi_challan.org_information10 Dep_Base_Branch
969: FROM hr_organization_information hoi_challan
970: WHERE hoi_challan.organization_id = p_pf_org
971: AND hoi_challan.org_information_context ='PER_IN_PF_BANK_PAYMENT_DETAILS'
972: AND hoi_challan.org_information3= p_challan_ref;
973:

Line 992: FROM hr_organization_information hoi_challan

988: ,hoi_challan.org_information12 Challan_Ref
989: ,hoi_challan.org_information13 Legal_Charges
990: ,hoi_challan.org_information14 Interest_Sec
991: ,hoi_challan.org_information15 Penalty
992: FROM hr_organization_information hoi_challan
993: WHERE hoi_challan.organization_id = p_pf_org
994: AND hoi_challan.org_information_context ='PER_IN_PF_CHALLAN_INFO'
995: AND hoi_challan.org_information12= p_challan_ref;
996:

Line 1008: FROM hr_organization_information hoi_challan

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

Line 1024: FROM hr_organization_information hoi_challan

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

Line 1043: FROM hr_organization_information hoi_challan

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

Line 1055: ,hr_organization_information hoi

1051: IS
1052: SELECT hoi.org_information3 branch_name
1053: ,hoi.org_information4 branch_add
1054: FROM hr_organization_units hou
1055: ,hr_organization_information hoi
1056: WHERE hoi.organization_id = hou.organization_id
1057: AND hoi.org_information_context = 'PER_IN_PF_BANK_BRANCH_DTLS'
1058: AND hou.business_group_id = g_bg_id
1059: AND hoi.org_information1 = p_bank_code

Line 1352: hr_organization_information hoi

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

Line 1388: hr_organization_information hoi

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

Line 1413: ,hr_organization_information hoi

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

Line 1435: hr_organization_information hoi

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

Line 1462: ,hr_organization_information hoi

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

Line 1494: hr_organization_information hoi

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

Line 1528: FROM hr_organization_information hoi_challan

1524: ,p_business_no NUMBER )
1525: IS
1526: SELECT
1527: hoi_challan.org_information12 Challan_Ref
1528: FROM hr_organization_information hoi_challan
1529: WHERE hoi_challan.organization_id = p_pf_org
1530: AND hoi_challan.org_information_context ='PER_IN_PF_CHALLAN_INFO'
1531: AND hoi_challan.org_information1 = g_challan_year
1532: AND hoi_challan.org_information2 = g_challan_mth

Line 1548: FROM hr_organization_information hoi ,

1544: AND pai.action_context_id IN
1545: (SELECT action_context_id
1546: FROM pay_action_information painfo
1547: WHERE painfo.action_information2 IN (SELECT hoi.org_information7
1548: FROM hr_organization_information hoi ,
1549: hr_organization_units hou
1550: WHERE hoi.organization_id = hou.organization_id
1551: AND hoi.org_information_context = 'PER_IN_COMPANY_RECEP_MAP'
1552: AND hoi.org_information3 = p_business_no

Line 1565: FROM hr_organization_information hoi_challan

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

Line 1580: FROM hr_organization_information

1576: */
1577: CURSOR csr_reg_return
1578: IS
1579: SELECT org_information3 bus_no
1580: FROM hr_organization_information
1581: WHERE org_information_context = 'PER_IN_COMPANY_RECEP_MAP'
1582: AND org_information1 = g_challan_year
1583: AND org_information2 = g_challan_mth
1584: AND org_information3 = NVL(g_business_no , org_information3)

Line 1591: FROM hr_organization_information

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

Line 1622: FROM hr_organization_information hr_pf_org

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

Line 1944: FROM hr_organization_information hr_pf_org

1940: IS
1941: SELECT hr_pf_org.organization_id pf_org,
1942: org_information10 base_bus_no,
1943: org_information10||org_information9 business_number
1944: FROM hr_organization_information hr_pf_org
1945: ,hr_organization_units hou
1946: WHERE hou.organization_id = hr_pf_org.organization_id
1947: AND hou.business_group_id = g_bg_id
1948: AND org_information_context = 'PER_IN_PF_DF'

Line 1959: FROM hr_organization_information hoi_challan

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