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

Line 403: ,hr_organization_information hoi

399: AND peev.effective_start_date <= g_fin_end_date
400: AND peev.effective_end_date >= g_fin_start_date
401: AND peev.screen_entry_value in (SELECT bank.org_information4||' - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
402: FROM hr_organization_units hou
403: ,hr_organization_information hoi
404: ,hr_organization_information bank
405: WHERE hoi.organization_id = hou.organization_id
406: AND hou.business_group_id = g_bg_id
407: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'

Line 404: ,hr_organization_information bank

400: AND peev.effective_end_date >= g_fin_start_date
401: AND peev.screen_entry_value in (SELECT bank.org_information4||' - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
402: FROM hr_organization_units hou
403: ,hr_organization_information hoi
404: ,hr_organization_information bank
405: WHERE hoi.organization_id = hou.organization_id
406: AND hou.business_group_id = g_bg_id
407: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
408: AND hoi.org_information1 = g_tax_year

Line 417: ,hr_organization_information hoi

413: AND hoi.organization_id LIKE g_gre_id
414: UNION
415: SELECT 'BOOK - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
416: FROM hr_organization_units hou
417: ,hr_organization_information hoi
418: WHERE hoi.organization_id = hou.organization_id
419: AND hou.business_group_id = g_bg_id
420: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
421: AND hoi.org_information1 = g_tax_year

Line 523: FROM hr_organization_information hoi_challan

519: ,hoi_challan.org_information10 others
520: ,hoi_challan.org_information11 dd_cheq_num
521: ,hoi_challan.org_information12 book_entry
522: ,hoi_challan.org_information_id org_info_id
523: FROM hr_organization_information hoi_challan
524: WHERE hoi_challan.organization_id = p_gre_id
525: AND hoi_challan.org_information_context ='PER_IN_IT_CHALLAN_INFO'
526: AND hoi_challan.org_information1 = g_tax_year
527: AND hoi_challan.org_information13 = g_quarter

Line 534: FROM hr_organization_information hoi_bank

530:
531: CURSOR csr_challan_bank(p_bank_code VARCHAR2)
532: IS
533: SELECT hoi_bank.org_information4 Bank
534: FROM hr_organization_information hoi_bank
535: WHERE hoi_bank.organization_id = p_gre_id
536: AND hoi_bank.org_information_context = 'PER_IN_CHALLAN_BANK'
537: AND hoi_bank.org_information_id = p_bank_code;
538:

Line 540: (Payment_date hr_organization_information.org_information2%TYPE,

536: AND hoi_bank.org_information_context = 'PER_IN_CHALLAN_BANK'
537: AND hoi_bank.org_information_id = p_bank_code;
538:
539: TYPE t_challan_entry_asg_rec IS RECORD
540: (Payment_date hr_organization_information.org_information2%TYPE,
541: Bank hr_organization_information.org_information4%TYPE,
542: challan_number pay_element_entry_values_f.screen_entry_value%TYPE,
543: tax hr_organization_information.org_information4%TYPE,
544: remarks hr_organization_information.org_information4%TYPE,

Line 541: Bank hr_organization_information.org_information4%TYPE,

537: AND hoi_bank.org_information_id = p_bank_code;
538:
539: TYPE t_challan_entry_asg_rec IS RECORD
540: (Payment_date hr_organization_information.org_information2%TYPE,
541: Bank hr_organization_information.org_information4%TYPE,
542: challan_number pay_element_entry_values_f.screen_entry_value%TYPE,
543: tax hr_organization_information.org_information4%TYPE,
544: remarks hr_organization_information.org_information4%TYPE,
545: surcharge hr_organization_information.org_information4%TYPE,

Line 543: tax hr_organization_information.org_information4%TYPE,

539: TYPE t_challan_entry_asg_rec IS RECORD
540: (Payment_date hr_organization_information.org_information2%TYPE,
541: Bank hr_organization_information.org_information4%TYPE,
542: challan_number pay_element_entry_values_f.screen_entry_value%TYPE,
543: tax hr_organization_information.org_information4%TYPE,
544: remarks hr_organization_information.org_information4%TYPE,
545: surcharge hr_organization_information.org_information4%TYPE,
546: cess hr_organization_information.org_information4%TYPE,
547: interest hr_organization_information.org_information4%TYPE,

Line 544: remarks hr_organization_information.org_information4%TYPE,

540: (Payment_date hr_organization_information.org_information2%TYPE,
541: Bank hr_organization_information.org_information4%TYPE,
542: challan_number pay_element_entry_values_f.screen_entry_value%TYPE,
543: tax hr_organization_information.org_information4%TYPE,
544: remarks hr_organization_information.org_information4%TYPE,
545: surcharge hr_organization_information.org_information4%TYPE,
546: cess hr_organization_information.org_information4%TYPE,
547: interest hr_organization_information.org_information4%TYPE,
548: others hr_organization_information.org_information4%TYPE,

Line 545: surcharge hr_organization_information.org_information4%TYPE,

541: Bank hr_organization_information.org_information4%TYPE,
542: challan_number pay_element_entry_values_f.screen_entry_value%TYPE,
543: tax hr_organization_information.org_information4%TYPE,
544: remarks hr_organization_information.org_information4%TYPE,
545: surcharge hr_organization_information.org_information4%TYPE,
546: cess hr_organization_information.org_information4%TYPE,
547: interest hr_organization_information.org_information4%TYPE,
548: others hr_organization_information.org_information4%TYPE,
549: dd_cheq_num hr_organization_information.org_information4%TYPE,

Line 546: cess hr_organization_information.org_information4%TYPE,

542: challan_number pay_element_entry_values_f.screen_entry_value%TYPE,
543: tax hr_organization_information.org_information4%TYPE,
544: remarks hr_organization_information.org_information4%TYPE,
545: surcharge hr_organization_information.org_information4%TYPE,
546: cess hr_organization_information.org_information4%TYPE,
547: interest hr_organization_information.org_information4%TYPE,
548: others hr_organization_information.org_information4%TYPE,
549: dd_cheq_num hr_organization_information.org_information4%TYPE,
550: book_entry hr_organization_information.org_information4%TYPE,

Line 547: interest hr_organization_information.org_information4%TYPE,

543: tax hr_organization_information.org_information4%TYPE,
544: remarks hr_organization_information.org_information4%TYPE,
545: surcharge hr_organization_information.org_information4%TYPE,
546: cess hr_organization_information.org_information4%TYPE,
547: interest hr_organization_information.org_information4%TYPE,
548: others hr_organization_information.org_information4%TYPE,
549: dd_cheq_num hr_organization_information.org_information4%TYPE,
550: book_entry hr_organization_information.org_information4%TYPE,
551: org_info_id hr_organization_information.org_information_id%TYPE

Line 548: others hr_organization_information.org_information4%TYPE,

544: remarks hr_organization_information.org_information4%TYPE,
545: surcharge hr_organization_information.org_information4%TYPE,
546: cess hr_organization_information.org_information4%TYPE,
547: interest hr_organization_information.org_information4%TYPE,
548: others hr_organization_information.org_information4%TYPE,
549: dd_cheq_num hr_organization_information.org_information4%TYPE,
550: book_entry hr_organization_information.org_information4%TYPE,
551: org_info_id hr_organization_information.org_information_id%TYPE
552: );

Line 549: dd_cheq_num hr_organization_information.org_information4%TYPE,

545: surcharge hr_organization_information.org_information4%TYPE,
546: cess hr_organization_information.org_information4%TYPE,
547: interest hr_organization_information.org_information4%TYPE,
548: others hr_organization_information.org_information4%TYPE,
549: dd_cheq_num hr_organization_information.org_information4%TYPE,
550: book_entry hr_organization_information.org_information4%TYPE,
551: org_info_id hr_organization_information.org_information_id%TYPE
552: );
553: --

Line 550: book_entry hr_organization_information.org_information4%TYPE,

546: cess hr_organization_information.org_information4%TYPE,
547: interest hr_organization_information.org_information4%TYPE,
548: others hr_organization_information.org_information4%TYPE,
549: dd_cheq_num hr_organization_information.org_information4%TYPE,
550: book_entry hr_organization_information.org_information4%TYPE,
551: org_info_id hr_organization_information.org_information_id%TYPE
552: );
553: --
554:

Line 551: org_info_id hr_organization_information.org_information_id%TYPE

547: interest hr_organization_information.org_information4%TYPE,
548: others hr_organization_information.org_information4%TYPE,
549: dd_cheq_num hr_organization_information.org_information4%TYPE,
550: book_entry hr_organization_information.org_information4%TYPE,
551: org_info_id hr_organization_information.org_information_id%TYPE
552: );
553: --
554:
555: TYPE t_challan_entry_asg_tab_type IS TABLE OF t_challan_entry_asg_rec

Line 563: l_bank_code hr_organization_information.org_information4%TYPE;

559:
560: l_action_info_id NUMBER;
561: l_ovn NUMBER;
562: p_cnt NUMBER;
563: l_bank_code hr_organization_information.org_information4%TYPE;
564: l_proc VARCHAR2(100);
565: l_message VARCHAR2(255);
566: BEGIN
567:

Line 696: FROM hr_organization_information hoi

692: ,hoi.org_information12 ministry_name
693: ,hoi.org_information13 other_ministry_name
694: ,hoi.org_information14 pao_reg_code
695: ,hoi.org_information15 ddo_reg_code
696: FROM hr_organization_information hoi
697: ,hr_organization_units hou
698: WHERE hoi.organization_id = p_gre_id
699: AND hoi.org_information_context = 'PER_IN_INCOME_TAX_DF'
700: AND hou.organization_id = hoi.organization_id

Line 708: FROM hr_organization_information hoi

704: CURSOR c_reg_org_details(p_reg_org_id NUMBER)
705: IS
706: SELECT hoi.org_information3 pan
707: ,hoi.org_information4 legal_name
708: FROM hr_organization_information hoi
709: ,hr_organization_units hou
710: WHERE hoi.organization_id = p_reg_org_id
711: AND hoi.org_information_context = 'PER_IN_COMPANY_DF'
712: AND hou.organization_id = hoi.organization_id

Line 737: FROM hr_organization_information hoi

733: IS
734: SELECT hoi.org_information1 person_id
735: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) rep_name
736: ,pep.email_address email_id
737: FROM hr_organization_information hoi
738: ,hr_organization_units hou
739: ,per_people_f pep
740: WHERE hoi.org_information_context = 'PER_IN_INCOME_TAX_REP_DF'
741: AND hoi.organization_id = p_gre_id

Line 792: l_tan hr_organization_information.org_information1%TYPE;

788: AND action_context_id = p_arc_pay_action_id
789: AND action_information3 = p_gre_id
790: AND action_information2 = g_year||g_quarter;
791:
792: l_tan hr_organization_information.org_information1%TYPE;
793: l_er_class hr_organization_information.org_information3%TYPE;
794: l_er_24q_class hr_organization_information.org_information6%TYPE;
795: l_reg_org_id hr_organization_information.org_information4%TYPE;
796: l_division hr_organization_information.org_information7%TYPE;

Line 793: l_er_class hr_organization_information.org_information3%TYPE;

789: AND action_information3 = p_gre_id
790: AND action_information2 = g_year||g_quarter;
791:
792: l_tan hr_organization_information.org_information1%TYPE;
793: l_er_class hr_organization_information.org_information3%TYPE;
794: l_er_24q_class hr_organization_information.org_information6%TYPE;
795: l_reg_org_id hr_organization_information.org_information4%TYPE;
796: l_division hr_organization_information.org_information7%TYPE;
797: l_location_id hr_organization_units.location_id%TYPE;

Line 794: l_er_24q_class hr_organization_information.org_information6%TYPE;

790: AND action_information2 = g_year||g_quarter;
791:
792: l_tan hr_organization_information.org_information1%TYPE;
793: l_er_class hr_organization_information.org_information3%TYPE;
794: l_er_24q_class hr_organization_information.org_information6%TYPE;
795: l_reg_org_id hr_organization_information.org_information4%TYPE;
796: l_division hr_organization_information.org_information7%TYPE;
797: l_location_id hr_organization_units.location_id%TYPE;
798: l_pan hr_organization_information.org_information3%TYPE;

Line 795: l_reg_org_id hr_organization_information.org_information4%TYPE;

791:
792: l_tan hr_organization_information.org_information1%TYPE;
793: l_er_class hr_organization_information.org_information3%TYPE;
794: l_er_24q_class hr_organization_information.org_information6%TYPE;
795: l_reg_org_id hr_organization_information.org_information4%TYPE;
796: l_division hr_organization_information.org_information7%TYPE;
797: l_location_id hr_organization_units.location_id%TYPE;
798: l_pan hr_organization_information.org_information3%TYPE;
799: l_legal_name hr_organization_information.org_information4%TYPE;

Line 796: l_division hr_organization_information.org_information7%TYPE;

792: l_tan hr_organization_information.org_information1%TYPE;
793: l_er_class hr_organization_information.org_information3%TYPE;
794: l_er_24q_class hr_organization_information.org_information6%TYPE;
795: l_reg_org_id hr_organization_information.org_information4%TYPE;
796: l_division hr_organization_information.org_information7%TYPE;
797: l_location_id hr_organization_units.location_id%TYPE;
798: l_pan hr_organization_information.org_information3%TYPE;
799: l_legal_name hr_organization_information.org_information4%TYPE;
800: l_state hr_organization_information.org_information9%TYPE;

Line 798: l_pan hr_organization_information.org_information3%TYPE;

794: l_er_24q_class hr_organization_information.org_information6%TYPE;
795: l_reg_org_id hr_organization_information.org_information4%TYPE;
796: l_division hr_organization_information.org_information7%TYPE;
797: l_location_id hr_organization_units.location_id%TYPE;
798: l_pan hr_organization_information.org_information3%TYPE;
799: l_legal_name hr_organization_information.org_information4%TYPE;
800: l_state hr_organization_information.org_information9%TYPE;
801: l_pao_code hr_organization_information.org_information10%TYPE;
802: l_ddo_code hr_organization_information.org_information11%TYPE;

Line 799: l_legal_name hr_organization_information.org_information4%TYPE;

795: l_reg_org_id hr_organization_information.org_information4%TYPE;
796: l_division hr_organization_information.org_information7%TYPE;
797: l_location_id hr_organization_units.location_id%TYPE;
798: l_pan hr_organization_information.org_information3%TYPE;
799: l_legal_name hr_organization_information.org_information4%TYPE;
800: l_state hr_organization_information.org_information9%TYPE;
801: l_pao_code hr_organization_information.org_information10%TYPE;
802: l_ddo_code hr_organization_information.org_information11%TYPE;
803: l_ministry_name hr_organization_information.org_information12%TYPE;

Line 800: l_state hr_organization_information.org_information9%TYPE;

796: l_division hr_organization_information.org_information7%TYPE;
797: l_location_id hr_organization_units.location_id%TYPE;
798: l_pan hr_organization_information.org_information3%TYPE;
799: l_legal_name hr_organization_information.org_information4%TYPE;
800: l_state hr_organization_information.org_information9%TYPE;
801: l_pao_code hr_organization_information.org_information10%TYPE;
802: l_ddo_code hr_organization_information.org_information11%TYPE;
803: l_ministry_name hr_organization_information.org_information12%TYPE;
804: l_other_ministry_name hr_organization_information.org_information13%TYPE;

Line 801: l_pao_code hr_organization_information.org_information10%TYPE;

797: l_location_id hr_organization_units.location_id%TYPE;
798: l_pan hr_organization_information.org_information3%TYPE;
799: l_legal_name hr_organization_information.org_information4%TYPE;
800: l_state hr_organization_information.org_information9%TYPE;
801: l_pao_code hr_organization_information.org_information10%TYPE;
802: l_ddo_code hr_organization_information.org_information11%TYPE;
803: l_ministry_name hr_organization_information.org_information12%TYPE;
804: l_other_ministry_name hr_organization_information.org_information13%TYPE;
805: l_pao_reg_code hr_organization_information.org_information14%TYPE;

Line 802: l_ddo_code hr_organization_information.org_information11%TYPE;

798: l_pan hr_organization_information.org_information3%TYPE;
799: l_legal_name hr_organization_information.org_information4%TYPE;
800: l_state hr_organization_information.org_information9%TYPE;
801: l_pao_code hr_organization_information.org_information10%TYPE;
802: l_ddo_code hr_organization_information.org_information11%TYPE;
803: l_ministry_name hr_organization_information.org_information12%TYPE;
804: l_other_ministry_name hr_organization_information.org_information13%TYPE;
805: l_pao_reg_code hr_organization_information.org_information14%TYPE;
806: l_ddo_reg_code hr_organization_information.org_information15%TYPE;

Line 803: l_ministry_name hr_organization_information.org_information12%TYPE;

799: l_legal_name hr_organization_information.org_information4%TYPE;
800: l_state hr_organization_information.org_information9%TYPE;
801: l_pao_code hr_organization_information.org_information10%TYPE;
802: l_ddo_code hr_organization_information.org_information11%TYPE;
803: l_ministry_name hr_organization_information.org_information12%TYPE;
804: l_other_ministry_name hr_organization_information.org_information13%TYPE;
805: l_pao_reg_code hr_organization_information.org_information14%TYPE;
806: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
807: l_rep_person_id per_all_people_f.person_id%TYPE;

Line 804: l_other_ministry_name hr_organization_information.org_information13%TYPE;

800: l_state hr_organization_information.org_information9%TYPE;
801: l_pao_code hr_organization_information.org_information10%TYPE;
802: l_ddo_code hr_organization_information.org_information11%TYPE;
803: l_ministry_name hr_organization_information.org_information12%TYPE;
804: l_other_ministry_name hr_organization_information.org_information13%TYPE;
805: l_pao_reg_code hr_organization_information.org_information14%TYPE;
806: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
807: l_rep_person_id per_all_people_f.person_id%TYPE;
808: l_rep_name per_all_people_f.full_name%TYPE;

Line 805: l_pao_reg_code hr_organization_information.org_information14%TYPE;

801: l_pao_code hr_organization_information.org_information10%TYPE;
802: l_ddo_code hr_organization_information.org_information11%TYPE;
803: l_ministry_name hr_organization_information.org_information12%TYPE;
804: l_other_ministry_name hr_organization_information.org_information13%TYPE;
805: l_pao_reg_code hr_organization_information.org_information14%TYPE;
806: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
807: l_rep_person_id per_all_people_f.person_id%TYPE;
808: l_rep_name per_all_people_f.full_name%TYPE;
809: l_position per_all_positions.name%TYPE;

Line 806: l_ddo_reg_code hr_organization_information.org_information15%TYPE;

802: l_ddo_code hr_organization_information.org_information11%TYPE;
803: l_ministry_name hr_organization_information.org_information12%TYPE;
804: l_other_ministry_name hr_organization_information.org_information13%TYPE;
805: l_pao_reg_code hr_organization_information.org_information14%TYPE;
806: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
807: l_rep_person_id per_all_people_f.person_id%TYPE;
808: l_rep_name per_all_people_f.full_name%TYPE;
809: l_position per_all_positions.name%TYPE;
810: l_rep_location hr_organization_units.location_id%TYPE;

Line 2280: ,hr_organization_information hoi

2276: AND pee.effective_end_date >= g_fin_start_date
2277: AND pee.assignment_id = p_assignment_id
2278: AND EXISTS (SELECT ''
2279: FROM pay_element_entry_values_f peev
2280: ,hr_organization_information hoi
2281: WHERE peev.input_value_id = g_input_table_rec(1).input_value_id
2282: AND peev.element_entry_id = pee.element_entry_id
2283: AND peev.screen_entry_value LIKE '% - '|| hoi.org_information3|| ' - %'||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR')
2284: AND hoi.organization_id = p_gre_id