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 980: ,hr_organization_units hou

976: AND pay_in_utils.get_ee_value(entry.element_entry_id,'Challan or Voucher Number') IN
977: (
978: SELECT hoi.org_information3
979: FROM hr_organization_information hoi
980: ,hr_organization_units hou
981: WHERE hoi.organization_id = g_gre_id
982: AND hoi.organization_id = hou.organization_id
983: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
984: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'

Line 1005: ,hr_organization_units hou

1001: AND action_information15 IN
1002: (
1003: SELECT hoi.org_information3
1004: FROM hr_organization_information hoi
1005: ,hr_organization_units hou
1006: WHERE hoi.organization_id = g_gre_id
1007: AND hoi.organization_id = hou.organization_id
1008: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1009: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'

Line 1038: ,hr_organization_units hou

1034: AND action_information15 IN
1035: (
1036: SELECT hoi.org_information3
1037: FROM hr_organization_information hoi
1038: ,hr_organization_units hou
1039: WHERE hoi.organization_id = g_gre_id
1040: AND hoi.organization_id = hou.organization_id
1041: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1042: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'

Line 2728: ,hr_organization_units hou

2724: ,hoi.org_information4 reg_org_id
2725: ,hoi.org_information7 division
2726: ,hou.location_id location_id
2727: FROM hr_organization_information hoi
2728: ,hr_organization_units hou
2729: WHERE hoi.organization_id = p_gre_id
2730: AND hoi.org_information_context = 'PER_IN_INCOME_TAX_DF'
2731: AND hou.organization_id = hoi.organization_id
2732: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 2740: ,hr_organization_units hou

2736: IS
2737: SELECT hoi.org_information3 pan
2738: ,hoi.org_information4 legal_name
2739: FROM hr_organization_information hoi
2740: ,hr_organization_units hou
2741: WHERE hoi.organization_id = p_reg_org_id
2742: AND hoi.org_information_context = 'PER_IN_COMPANY_DF'
2743: AND hou.organization_id = hoi.organization_id
2744: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 2767: ,hr_organization_units hou

2763: CURSOR c_rep_address(p_person_id NUMBER)
2764: IS
2765: SELECT hou.location_id rep_location
2766: FROM per_assignments_f asg
2767: ,hr_organization_units hou
2768: WHERE asg.person_id = p_person_id
2769: AND asg.primary_flag = 'Y'
2770: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
2771: AND hou.organization_id = asg.organization_id

Line 2782: ,hr_organization_units hou

2778: SELECT pep.person_id
2779: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) rep_name
2780: ,pep.email_address email_id
2781: FROM hr_organization_information hoi
2782: ,hr_organization_units hou
2783: ,per_people_f pep
2784: WHERE hoi.org_information_context = 'PER_IN_INCOME_TAX_REP_DF'
2785: AND hoi.organization_id = p_gre_id
2786: AND hou.organization_id = hoi.organization_id

Line 2991: l_org_location hr_organization_units.location_id%TYPE;

2987: l_flag BOOLEAN;
2988: l_tan_number hr_organization_information.org_information1%TYPE;
2989: l_deductor_type hr_organization_information.org_information3%TYPE;
2990: l_branch_or_division hr_organization_information.org_information7%TYPE;
2991: l_org_location hr_organization_units.location_id%TYPE;
2992: l_pan_number hr_organization_information.org_information3%TYPE;
2993: l_legal_name hr_organization_information.org_information4%TYPE;
2994: l_rep_name per_all_people_f.full_name%TYPE;
2995: l_rep_position per_all_positions.name%TYPE;

Line 2996: l_rep_location hr_organization_units.location_id%TYPE;

2992: l_pan_number hr_organization_information.org_information3%TYPE;
2993: l_legal_name hr_organization_information.org_information4%TYPE;
2994: l_rep_name per_all_people_f.full_name%TYPE;
2995: l_rep_position per_all_positions.name%TYPE;
2996: l_rep_location hr_organization_units.location_id%TYPE;
2997: l_rep_email_id per_all_people_f.email_address%TYPE;
2998: l_rep_work_phone per_phones.phone_number%TYPE;
2999: l_rep_std_code per_phones.phone_number%TYPE;
3000: l_procedure VARCHAR2(250);

Line 3215: ,hr_organization_units hou

3211: WHERE hoi.org_information_id IN
3212: (
3213: SELECT hoi.org_information_id
3214: FROM hr_organization_information hoi
3215: ,hr_organization_units hou
3216: WHERE hoi.organization_id = p_gre_id
3217: AND hoi.organization_id = hou.organization_id
3218: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
3219: AND org_information_context = 'PER_IN_IT_CHALLAN_INFO'

Line 3257: ,hr_organization_units hou

3253: WHERE hoi.org_information_id IN
3254: (
3255: SELECT hoi.org_information_id
3256: FROM hr_organization_information hoi
3257: ,hr_organization_units hou
3258: WHERE hoi.organization_id = p_gre_id
3259: AND hoi.organization_id = hou.organization_id
3260: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
3261: AND org_information_context = 'PER_IN_IT_CHALLAN_INFO'

Line 6923: ,hr_organization_units hou

6919: WHERE hoi.org_information_id IN
6920: (
6921: SELECT hoi.org_information_id
6922: FROM hr_organization_information hoi
6923: ,hr_organization_units hou
6924: WHERE hoi.organization_id = g_gre_id
6925: AND hoi.organization_id = hou.organization_id
6926: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
6927: AND org_information_context = 'PER_IN_IT_CHALLAN_INFO'

Line 7117: ,hr_organization_units hou

7113: WHERE hoi.org_information_id IN
7114: (
7115: SELECT hoi.org_information_id
7116: FROM hr_organization_information hoi
7117: ,hr_organization_units hou
7118: WHERE hoi.organization_id = g_gre_id
7119: AND hoi.organization_id = hou.organization_id
7120: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
7121: AND org_information_context = 'PER_IN_IT_CHALLAN_INFO'

Line 7567: l_org_location hr_organization_units.location_id%TYPE;

7563:
7564: l_tan_number hr_organization_information.org_information1%TYPE;
7565: l_deductor_type hr_organization_information.org_information3%TYPE;
7566: l_branch_or_division hr_organization_information.org_information7%TYPE;
7567: l_org_location hr_organization_units.location_id%TYPE;
7568: l_pan_number hr_organization_information.org_information3%TYPE;
7569: l_legal_name hr_organization_information.org_information4%TYPE;
7570: l_rep_name per_all_people_f.full_name%TYPE;
7571: l_rep_position per_all_positions.name%TYPE;

Line 7572: l_rep_location hr_organization_units.location_id%TYPE;

7568: l_pan_number hr_organization_information.org_information3%TYPE;
7569: l_legal_name hr_organization_information.org_information4%TYPE;
7570: l_rep_name per_all_people_f.full_name%TYPE;
7571: l_rep_position per_all_positions.name%TYPE;
7572: l_rep_location hr_organization_units.location_id%TYPE;
7573: l_rep_email_id per_all_people_f.email_address%TYPE;
7574: l_rep_work_phone per_phones.phone_number%TYPE;
7575: l_rep_std_code per_phones.phone_number%TYPE;
7576:

Line 8086: l_org_location hr_organization_units.location_id%TYPE;

8082: l_challan_deductee_no VARCHAR2(250);
8083: l_tan_number hr_organization_information.org_information1%TYPE;
8084: l_deductor_type hr_organization_information.org_information3%TYPE;
8085: l_branch_or_division hr_organization_information.org_information7%TYPE;
8086: l_org_location hr_organization_units.location_id%TYPE;
8087: l_pan_number hr_organization_information.org_information3%TYPE;
8088: l_legal_name hr_organization_information.org_information4%TYPE;
8089: l_rep_name per_all_people_f.full_name%TYPE;
8090: l_rep_position per_all_positions.name%TYPE;

Line 8091: l_rep_location hr_organization_units.location_id%TYPE;

8087: l_pan_number hr_organization_information.org_information3%TYPE;
8088: l_legal_name hr_organization_information.org_information4%TYPE;
8089: l_rep_name per_all_people_f.full_name%TYPE;
8090: l_rep_position per_all_positions.name%TYPE;
8091: l_rep_location hr_organization_units.location_id%TYPE;
8092: l_rep_email_id per_all_people_f.email_address%TYPE;
8093: l_rep_work_phone per_phones.phone_number%TYPE;
8094: l_rep_std_code per_phones.phone_number%TYPE;
8095: l_flag_number NUMBER := -1;