[Home] [Help]
152: IS
153: SELECT 1
154: FROM pay_action_information pai
155: ,pay_payroll_actions ppa
156: ,hr_organization_units hou
157: WHERE pai.action_information_category = 'IN_24Q_ORG'
158: AND pai.action_context_type = 'PA'
159: AND pai.action_information1 like g_gre_id
160: AND pai.action_information3 = g_year||g_quarter
398: AND peev.element_entry_id = pee.element_entry_id
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
412: AND hoi.org_information13 = g_quarter
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'
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
701: AND hou.business_group_id = g_bg_id
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
713: AND hou.business_group_id = g_bg_id
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
742: AND hou.organization_id = hoi.organization_id
751: CURSOR c_rep_address(p_person_id NUMBER)
752: IS
753: SELECT hou.location_id rep_location
754: FROM per_assignments_f asg
755: ,hr_organization_units hou
756: WHERE asg.person_id = p_person_id
757: AND asg.primary_flag = 'Y'
758: AND asg.business_group_id = g_bg_id
759: AND hou.organization_id = asg.organization_id
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;
801: l_pao_code hr_organization_information.org_information10%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;
811: l_rep_phone_no per_phones.phone_number%TYPE;
812: l_rep_mobile_no per_phones.phone_number%TYPE; -- Bug 12332524
813: l_rep_email_id per_all_people_f.email_address%TYPE;
814: l_action_info_id NUMBER;