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 398: ,hr_organization_information hoi

394: AND pee.effective_end_date >= g_fin_start_date
395: AND pee.assignment_id = paf1.assignment_id
396: AND EXISTS (SELECT ''
397: FROM pay_element_entry_values_f peev
398: ,hr_organization_information hoi
399: WHERE peev.input_value_id = g_input_table_rec(1).input_value_id
400: AND peev.element_entry_id = pee.element_entry_id
401: AND peev.screen_entry_value = hoi.org_information3
402: AND hoi.org_information1 = g_tax_year

Line 505: FROM hr_organization_information hoi_challan

501: ,hoi_challan.org_information10 others
502: ,hoi_challan.org_information11 dd_cheq_num
503: ,hoi_challan.org_information12 book_entry
504: ,hoi_challan.org_information_id org_info_id
505: FROM hr_organization_information hoi_challan
506: WHERE hoi_challan.organization_id = p_gre_id
507: AND hoi_challan.org_information_context ='PER_IN_IT_CHALLAN_INFO'
508: AND hoi_challan.org_information1 = g_tax_year
509: AND hoi_challan.org_information13 = g_quarter

Line 516: FROM hr_organization_information hoi_bank

512:
513: CURSOR csr_challan_bank(p_bank_code VARCHAR2)
514: IS
515: SELECT hoi_bank.org_information4 Bank
516: FROM hr_organization_information hoi_bank
517: WHERE hoi_bank.organization_id = p_gre_id
518: AND hoi_bank.org_information_context = 'PER_IN_CHALLAN_BANK'
519: AND hoi_bank.org_information_id = p_bank_code;
520:

Line 522: (Payment_date hr_organization_information.org_information2%TYPE,

518: AND hoi_bank.org_information_context = 'PER_IN_CHALLAN_BANK'
519: AND hoi_bank.org_information_id = p_bank_code;
520:
521: TYPE t_challan_entry_asg_rec IS RECORD
522: (Payment_date hr_organization_information.org_information2%TYPE,
523: Bank hr_organization_information.org_information4%TYPE,
524: challan_number pay_element_entry_values_f.screen_entry_value%TYPE,
525: tax hr_organization_information.org_information4%TYPE,
526: remarks hr_organization_information.org_information4%TYPE,

Line 523: Bank hr_organization_information.org_information4%TYPE,

519: AND hoi_bank.org_information_id = p_bank_code;
520:
521: TYPE t_challan_entry_asg_rec IS RECORD
522: (Payment_date hr_organization_information.org_information2%TYPE,
523: Bank hr_organization_information.org_information4%TYPE,
524: challan_number pay_element_entry_values_f.screen_entry_value%TYPE,
525: tax hr_organization_information.org_information4%TYPE,
526: remarks hr_organization_information.org_information4%TYPE,
527: surcharge hr_organization_information.org_information4%TYPE,

Line 525: tax hr_organization_information.org_information4%TYPE,

521: TYPE t_challan_entry_asg_rec IS RECORD
522: (Payment_date hr_organization_information.org_information2%TYPE,
523: Bank hr_organization_information.org_information4%TYPE,
524: challan_number pay_element_entry_values_f.screen_entry_value%TYPE,
525: tax hr_organization_information.org_information4%TYPE,
526: remarks hr_organization_information.org_information4%TYPE,
527: surcharge hr_organization_information.org_information4%TYPE,
528: cess hr_organization_information.org_information4%TYPE,
529: interest hr_organization_information.org_information4%TYPE,

Line 526: remarks hr_organization_information.org_information4%TYPE,

522: (Payment_date hr_organization_information.org_information2%TYPE,
523: Bank hr_organization_information.org_information4%TYPE,
524: challan_number pay_element_entry_values_f.screen_entry_value%TYPE,
525: tax hr_organization_information.org_information4%TYPE,
526: remarks hr_organization_information.org_information4%TYPE,
527: surcharge hr_organization_information.org_information4%TYPE,
528: cess hr_organization_information.org_information4%TYPE,
529: interest hr_organization_information.org_information4%TYPE,
530: others hr_organization_information.org_information4%TYPE,

Line 527: surcharge hr_organization_information.org_information4%TYPE,

523: Bank hr_organization_information.org_information4%TYPE,
524: challan_number pay_element_entry_values_f.screen_entry_value%TYPE,
525: tax hr_organization_information.org_information4%TYPE,
526: remarks hr_organization_information.org_information4%TYPE,
527: surcharge hr_organization_information.org_information4%TYPE,
528: cess hr_organization_information.org_information4%TYPE,
529: interest hr_organization_information.org_information4%TYPE,
530: others hr_organization_information.org_information4%TYPE,
531: dd_cheq_num hr_organization_information.org_information4%TYPE,

Line 528: cess hr_organization_information.org_information4%TYPE,

524: challan_number pay_element_entry_values_f.screen_entry_value%TYPE,
525: tax hr_organization_information.org_information4%TYPE,
526: remarks hr_organization_information.org_information4%TYPE,
527: surcharge hr_organization_information.org_information4%TYPE,
528: cess hr_organization_information.org_information4%TYPE,
529: interest hr_organization_information.org_information4%TYPE,
530: others hr_organization_information.org_information4%TYPE,
531: dd_cheq_num hr_organization_information.org_information4%TYPE,
532: book_entry hr_organization_information.org_information4%TYPE,

Line 529: interest hr_organization_information.org_information4%TYPE,

525: tax hr_organization_information.org_information4%TYPE,
526: remarks hr_organization_information.org_information4%TYPE,
527: surcharge hr_organization_information.org_information4%TYPE,
528: cess hr_organization_information.org_information4%TYPE,
529: interest hr_organization_information.org_information4%TYPE,
530: others hr_organization_information.org_information4%TYPE,
531: dd_cheq_num hr_organization_information.org_information4%TYPE,
532: book_entry hr_organization_information.org_information4%TYPE,
533: org_info_id hr_organization_information.org_information_id%TYPE

Line 530: others hr_organization_information.org_information4%TYPE,

526: remarks hr_organization_information.org_information4%TYPE,
527: surcharge hr_organization_information.org_information4%TYPE,
528: cess hr_organization_information.org_information4%TYPE,
529: interest hr_organization_information.org_information4%TYPE,
530: others hr_organization_information.org_information4%TYPE,
531: dd_cheq_num hr_organization_information.org_information4%TYPE,
532: book_entry hr_organization_information.org_information4%TYPE,
533: org_info_id hr_organization_information.org_information_id%TYPE
534: );

Line 531: dd_cheq_num hr_organization_information.org_information4%TYPE,

527: surcharge hr_organization_information.org_information4%TYPE,
528: cess hr_organization_information.org_information4%TYPE,
529: interest hr_organization_information.org_information4%TYPE,
530: others hr_organization_information.org_information4%TYPE,
531: dd_cheq_num hr_organization_information.org_information4%TYPE,
532: book_entry hr_organization_information.org_information4%TYPE,
533: org_info_id hr_organization_information.org_information_id%TYPE
534: );
535: --

Line 532: book_entry hr_organization_information.org_information4%TYPE,

528: cess hr_organization_information.org_information4%TYPE,
529: interest hr_organization_information.org_information4%TYPE,
530: others hr_organization_information.org_information4%TYPE,
531: dd_cheq_num hr_organization_information.org_information4%TYPE,
532: book_entry hr_organization_information.org_information4%TYPE,
533: org_info_id hr_organization_information.org_information_id%TYPE
534: );
535: --
536:

Line 533: org_info_id hr_organization_information.org_information_id%TYPE

529: interest hr_organization_information.org_information4%TYPE,
530: others hr_organization_information.org_information4%TYPE,
531: dd_cheq_num hr_organization_information.org_information4%TYPE,
532: book_entry hr_organization_information.org_information4%TYPE,
533: org_info_id hr_organization_information.org_information_id%TYPE
534: );
535: --
536:
537: TYPE t_challan_entry_asg_tab_type IS TABLE OF t_challan_entry_asg_rec

Line 545: l_bank_code hr_organization_information.org_information4%TYPE;

541:
542: l_action_info_id NUMBER;
543: l_ovn NUMBER;
544: p_cnt NUMBER;
545: l_bank_code hr_organization_information.org_information4%TYPE;
546: l_proc VARCHAR2(100);
547: l_message VARCHAR2(255);
548: BEGIN
549:

Line 669: FROM hr_organization_information hoi

665: ,hoi.org_information3 er_class
666: ,hoi.org_information4 reg_org_id
667: ,hoi.org_information7 division
668: ,hou.location_id location_id
669: FROM hr_organization_information hoi
670: ,hr_organization_units hou
671: WHERE hoi.organization_id = p_gre_id
672: AND hoi.org_information_context = 'PER_IN_INCOME_TAX_DF'
673: AND hou.organization_id = hoi.organization_id

Line 681: FROM hr_organization_information hoi

677: CURSOR c_reg_org_details(p_reg_org_id NUMBER)
678: IS
679: SELECT hoi.org_information3 pan
680: ,hoi.org_information4 legal_name
681: FROM hr_organization_information hoi
682: ,hr_organization_units hou
683: WHERE hoi.organization_id = p_reg_org_id
684: AND hoi.org_information_context = 'PER_IN_COMPANY_DF'
685: AND hou.organization_id = hoi.organization_id

Line 710: FROM hr_organization_information hoi

706: IS
707: SELECT hoi.org_information1 person_id
708: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) rep_name
709: ,pep.email_address email_id
710: FROM hr_organization_information hoi
711: ,hr_organization_units hou
712: ,per_people_f pep
713: WHERE hoi.org_information_context = 'PER_IN_INCOME_TAX_REP_DF'
714: AND hoi.organization_id = p_gre_id

Line 755: l_tan hr_organization_information.org_information1%TYPE;

751: AND action_context_id = p_arc_pay_action_id
752: AND action_information3 = p_gre_id
753: AND action_information2 = g_year||g_quarter;
754:
755: l_tan hr_organization_information.org_information1%TYPE;
756: l_er_class hr_organization_information.org_information3%TYPE;
757: l_reg_org_id hr_organization_information.org_information4%TYPE;
758: l_division hr_organization_information.org_information7%TYPE;
759: l_location_id hr_organization_units.location_id%TYPE;

Line 756: l_er_class hr_organization_information.org_information3%TYPE;

752: AND action_information3 = p_gre_id
753: AND action_information2 = g_year||g_quarter;
754:
755: l_tan hr_organization_information.org_information1%TYPE;
756: l_er_class hr_organization_information.org_information3%TYPE;
757: l_reg_org_id hr_organization_information.org_information4%TYPE;
758: l_division hr_organization_information.org_information7%TYPE;
759: l_location_id hr_organization_units.location_id%TYPE;
760: l_pan hr_organization_information.org_information3%TYPE;

Line 757: l_reg_org_id hr_organization_information.org_information4%TYPE;

753: AND action_information2 = g_year||g_quarter;
754:
755: l_tan hr_organization_information.org_information1%TYPE;
756: l_er_class hr_organization_information.org_information3%TYPE;
757: l_reg_org_id hr_organization_information.org_information4%TYPE;
758: l_division hr_organization_information.org_information7%TYPE;
759: l_location_id hr_organization_units.location_id%TYPE;
760: l_pan hr_organization_information.org_information3%TYPE;
761: l_legal_name hr_organization_information.org_information4%TYPE;

Line 758: l_division hr_organization_information.org_information7%TYPE;

754:
755: l_tan hr_organization_information.org_information1%TYPE;
756: l_er_class hr_organization_information.org_information3%TYPE;
757: l_reg_org_id hr_organization_information.org_information4%TYPE;
758: l_division hr_organization_information.org_information7%TYPE;
759: l_location_id hr_organization_units.location_id%TYPE;
760: l_pan hr_organization_information.org_information3%TYPE;
761: l_legal_name hr_organization_information.org_information4%TYPE;
762: l_rep_person_id per_all_people_f.person_id%TYPE;

Line 760: l_pan hr_organization_information.org_information3%TYPE;

756: l_er_class hr_organization_information.org_information3%TYPE;
757: l_reg_org_id hr_organization_information.org_information4%TYPE;
758: l_division hr_organization_information.org_information7%TYPE;
759: l_location_id hr_organization_units.location_id%TYPE;
760: l_pan hr_organization_information.org_information3%TYPE;
761: l_legal_name hr_organization_information.org_information4%TYPE;
762: l_rep_person_id per_all_people_f.person_id%TYPE;
763: l_rep_name per_all_people_f.full_name%TYPE;
764: l_position per_all_positions.name%TYPE;

Line 761: l_legal_name hr_organization_information.org_information4%TYPE;

757: l_reg_org_id hr_organization_information.org_information4%TYPE;
758: l_division hr_organization_information.org_information7%TYPE;
759: l_location_id hr_organization_units.location_id%TYPE;
760: l_pan hr_organization_information.org_information3%TYPE;
761: l_legal_name hr_organization_information.org_information4%TYPE;
762: l_rep_person_id per_all_people_f.person_id%TYPE;
763: l_rep_name per_all_people_f.full_name%TYPE;
764: l_position per_all_positions.name%TYPE;
765: l_rep_location hr_organization_units.location_id%TYPE;

Line 2174: ,hr_organization_information hoi

2170: AND pee.effective_end_date >= g_fin_start_date
2171: AND pee.assignment_id = p_assignment_id
2172: AND EXISTS (SELECT ''
2173: FROM pay_element_entry_values_f peev
2174: ,hr_organization_information hoi
2175: WHERE peev.input_value_id = g_input_table_rec(1).input_value_id
2176: AND peev.element_entry_id = pee.element_entry_id
2177: AND peev.screen_entry_value = hoi.org_information3
2178: AND hoi.organization_id = p_gre_id