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_24QC_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 540: ,hr_organization_units hou

536: END IF;
537:
538: SELECT hoi.org_information1 ,hoi.org_information6 into l_tan_number,l_deductor_type
539: FROM hr_organization_information hoi
540: ,hr_organization_units hou
541: WHERE hoi.organization_id = g_gre_id
542: AND hoi.org_information_context = 'PER_IN_INCOME_TAX_DF'
543: AND hou.organization_id = hoi.organization_id
544: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 1043: FROM hr_organization_units hou

1039: )
1040: )
1041: AND pay_in_utils.get_ee_value(entry.element_entry_id,'Challan or Voucher Number') IN
1042: (SELECT bank.org_information4||' - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
1043: FROM hr_organization_units hou
1044: ,hr_organization_information hoi
1045: ,hr_organization_information bank
1046: WHERE hoi.organization_id = hou.organization_id
1047: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 1057: FROM hr_organization_units hou

1053: AND hoi.org_information13 = g_quarter
1054: AND hoi.organization_id = g_gre_id
1055: UNION
1056: SELECT 'BOOK - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
1057: FROM hr_organization_units hou
1058: ,hr_organization_information hoi
1059: WHERE hoi.organization_id = hou.organization_id
1060: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1061: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'

Line 1083: FROM hr_organization_units hou

1079: AND action_information2 = g_year||g_quarter
1080: AND action_information15 IN
1081: (
1082: (SELECT bank.org_information4||' - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
1083: FROM hr_organization_units hou
1084: ,hr_organization_information hoi
1085: ,hr_organization_information bank
1086: WHERE hoi.organization_id = hou.organization_id
1087: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 1097: FROM hr_organization_units hou

1093: AND hoi.org_information13 = g_quarter
1094: AND hoi.organization_id = g_gre_id
1095: UNION
1096: SELECT 'BOOK - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
1097: FROM hr_organization_units hou
1098: ,hr_organization_information hoi
1099: WHERE hoi.organization_id = hou.organization_id
1100: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1101: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'

Line 1130: FROM hr_organization_units hou

1126: AND action_information_category = 'IN_24QC_CHALLAN'
1127: AND action_information2 = g_year||g_quarter
1128: AND action_information15 IN
1129: (SELECT bank.org_information4||' - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
1130: FROM hr_organization_units hou
1131: ,hr_organization_information hoi
1132: ,hr_organization_information bank
1133: WHERE hoi.organization_id = hou.organization_id
1134: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 1144: FROM hr_organization_units hou

1140: AND hoi.org_information13 = g_quarter
1141: AND hoi.organization_id = g_gre_id
1142: UNION
1143: SELECT 'BOOK - '||hoi.org_information3 ||' - ' ||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR') org_information3
1144: FROM hr_organization_units hou
1145: ,hr_organization_information hoi
1146: WHERE hoi.organization_id = hou.organization_id
1147: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1148: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'

Line 2850: ,hr_organization_units hou

2846: ,hoi.org_information13 other_ministry_name
2847: ,hoi.org_information14 pao_reg_code
2848: ,hoi.org_information15 ddo_reg_code
2849: FROM hr_organization_information hoi
2850: ,hr_organization_units hou
2851: WHERE hoi.organization_id = p_gre_id
2852: AND hoi.org_information_context = 'PER_IN_INCOME_TAX_DF'
2853: AND hou.organization_id = hoi.organization_id
2854: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 2862: ,hr_organization_units hou

2858: IS
2859: SELECT hoi.org_information3 pan
2860: ,hoi.org_information4 legal_name
2861: FROM hr_organization_information hoi
2862: ,hr_organization_units hou
2863: WHERE hoi.organization_id = p_reg_org_id
2864: AND hoi.org_information_context = 'PER_IN_COMPANY_DF'
2865: AND hou.organization_id = hoi.organization_id
2866: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 2889: ,hr_organization_units hou

2885: CURSOR c_rep_address(p_person_id NUMBER)
2886: IS
2887: SELECT hou.location_id rep_location
2888: FROM per_assignments_f asg
2889: ,hr_organization_units hou
2890: WHERE asg.person_id = p_person_id
2891: AND asg.primary_flag = 'Y'
2892: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
2893: AND hou.organization_id = asg.organization_id

Line 2904: ,hr_organization_units hou

2900: SELECT pep.person_id
2901: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) rep_name
2902: ,pep.email_address email_id
2903: FROM hr_organization_information hoi
2904: ,hr_organization_units hou
2905: ,per_people_f pep
2906: WHERE hoi.org_information_context = 'PER_IN_INCOME_TAX_REP_DF'
2907: AND hoi.organization_id = p_gre_id
2908: AND hou.organization_id = hoi.organization_id

Line 3204: l_org_location hr_organization_units.location_id%TYPE;

3200: l_flag BOOLEAN;
3201: l_tan_number hr_organization_information.org_information1%TYPE;
3202: l_deductor_type hr_organization_information.org_information3%TYPE;
3203: l_branch_or_division hr_organization_information.org_information7%TYPE;
3204: l_org_location hr_organization_units.location_id%TYPE;
3205: l_pan_number hr_organization_information.org_information3%TYPE;
3206: l_legal_name hr_organization_information.org_information4%TYPE;
3207: l_state hr_organization_information.org_information9%TYPE;
3208: l_pao_code hr_organization_information.org_information10%TYPE;

Line 3216: l_rep_location hr_organization_units.location_id%TYPE;

3212: l_pao_reg_code hr_organization_information.org_information14%TYPE;
3213: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
3214: l_rep_name per_all_people_f.full_name%TYPE;
3215: l_rep_position per_all_positions.name%TYPE;
3216: l_rep_location hr_organization_units.location_id%TYPE;
3217: l_rep_email_id per_all_people_f.email_address%TYPE;
3218: l_rep_work_phone per_phones.phone_number%TYPE;
3219: l_rep_std_code per_phones.phone_number%TYPE;
3220: l_procedure VARCHAR2(250);

Line 3532: ,hr_organization_units hou

3528: WHERE hoi.org_information_id IN
3529: (
3530: SELECT hoi.org_information_id
3531: FROM hr_organization_information hoi
3532: ,hr_organization_units hou
3533: WHERE hoi.organization_id = p_gre_id
3534: AND hoi.organization_id = hou.organization_id
3535: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
3536: AND org_information_context = 'PER_IN_IT_CHALLAN_INFO'

Line 3574: ,hr_organization_units hou

3570: WHERE hoi.org_information_id IN
3571: (
3572: SELECT hoi.org_information_id
3573: FROM hr_organization_information hoi
3574: ,hr_organization_units hou
3575: WHERE hoi.organization_id = p_gre_id
3576: AND hoi.organization_id = hou.organization_id
3577: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
3578: AND org_information_context = 'PER_IN_IT_CHALLAN_INFO'

Line 7247: ,hr_organization_units hou

7243: WHERE hoi.org_information_id IN
7244: (
7245: SELECT hoi.org_information_id
7246: FROM hr_organization_information hoi
7247: ,hr_organization_units hou
7248: WHERE hoi.organization_id = g_gre_id
7249: AND hoi.organization_id = hou.organization_id
7250: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
7251: AND org_information_context = 'PER_IN_IT_CHALLAN_INFO'

Line 7441: ,hr_organization_units hou

7437: WHERE hoi.org_information_id IN
7438: (
7439: SELECT hoi.org_information_id
7440: FROM hr_organization_information hoi
7441: ,hr_organization_units hou
7442: WHERE hoi.organization_id = g_gre_id
7443: AND hoi.organization_id = hou.organization_id
7444: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
7445: AND org_information_context = 'PER_IN_IT_CHALLAN_INFO'

Line 7909: l_org_location hr_organization_units.location_id%TYPE;

7905:
7906: l_tan_number hr_organization_information.org_information1%TYPE;
7907: l_deductor_type hr_organization_information.org_information3%TYPE;
7908: l_branch_or_division hr_organization_information.org_information7%TYPE;
7909: l_org_location hr_organization_units.location_id%TYPE;
7910: l_pan_number hr_organization_information.org_information3%TYPE;
7911: l_legal_name hr_organization_information.org_information4%TYPE;
7912: l_state hr_organization_information.org_information9%TYPE;
7913: l_pao_code hr_organization_information.org_information10%TYPE;

Line 7921: l_rep_location hr_organization_units.location_id%TYPE;

7917: l_pao_reg_code hr_organization_information.org_information14%TYPE;
7918: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
7919: l_rep_name per_all_people_f.full_name%TYPE;
7920: l_rep_position per_all_positions.name%TYPE;
7921: l_rep_location hr_organization_units.location_id%TYPE;
7922: l_rep_email_id per_all_people_f.email_address%TYPE;
7923: l_rep_work_phone per_phones.phone_number%TYPE;
7924: l_rep_std_code per_phones.phone_number%TYPE;
7925:

Line 8468: l_org_location hr_organization_units.location_id%TYPE;

8464: l_deductor_type hr_organization_information.org_information3%TYPE;
8465: l_emplr_type hr_organization_information.org_information3%TYPE;
8466: l_emplr_type_24Q hr_organization_information.org_information6%TYPE;
8467: l_branch_or_division hr_organization_information.org_information7%TYPE;
8468: l_org_location hr_organization_units.location_id%TYPE;
8469: l_pan_number hr_organization_information.org_information3%TYPE;
8470: l_legal_name hr_organization_information.org_information4%TYPE;
8471: l_state hr_organization_information.org_information9%TYPE;
8472: l_pao_code hr_organization_information.org_information10%TYPE;

Line 8480: l_rep_location hr_organization_units.location_id%TYPE;

8476: l_pao_reg_code hr_organization_information.org_information14%TYPE;
8477: l_ddo_reg_code hr_organization_information.org_information15%TYPE;
8478: l_rep_name per_all_people_f.full_name%TYPE;
8479: l_rep_position per_all_positions.name%TYPE;
8480: l_rep_location hr_organization_units.location_id%TYPE;
8481: l_rep_email_id per_all_people_f.email_address%TYPE;
8482: l_rep_work_phone per_phones.phone_number%TYPE;
8483: l_rep_std_code per_phones.phone_number%TYPE;
8484: l_flag_number NUMBER := -1;