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_IN_UTILITY

Line 1101: (pai.action_information12 <> hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title))

1097: (TO_NUMBER(remove_curr_format(pai.action_information5)) <> TO_NUMBER(remove_curr_format(pay_in_utils.get_ee_value(pai.source_id,'Taxable Income'))))
1098: OR
1099: (pai.action_information4 <> pay_in_utils.get_ee_value(pai.source_id,'Payment Date'))
1100: OR
1101: (pai.action_information12 <> hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title))
1102: OR
1103: (NVL(pai.action_information11,'0') <> NVL(pep.per_information14,'0'))
1104: OR(
1105: (

Line 1208: (pai.action_information10 <> hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title))

1204: (TO_NUMBER(remove_curr_format(pai.action_information5)) <> TO_NUMBER(remove_curr_format(pay_in_utils.get_ee_value(pai.source_id,'Taxable Income'))))
1205: OR
1206: (pai.action_information4 <> pay_in_utils.get_ee_value(pai.source_id,'Payment Date'))
1207: OR
1208: (pai.action_information10 <> hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title))
1209: OR(--Checking PAN Number
1210: (
1211: g_correction_mode IN ('C5','%')
1212: AND (pai.action_information9 NOT IN('APPLIEDFOR','PANNOTAVBL'))

Line 1265: (pai.action_information10 = hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title))

1261: (TO_NUMBER(remove_curr_format(pai.action_information5)) = TO_NUMBER(remove_curr_format(pay_in_utils.get_ee_value(pai.source_id,'Taxable Income'))))
1262: AND
1263: (pai.action_information4 = pay_in_utils.get_ee_value(pai.source_id,'Payment Date'))
1264: AND
1265: (pai.action_information10 = hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title))
1266: AND(--Checking PAN Number
1267: (
1268: g_correction_mode IN ('C5','%')
1269: AND (pai.action_information9 NOT IN('APPLIEDFOR','PANNOTAVBL'))

Line 2060: (pai.action_information6 <> hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title))

2056: OR
2057: (FND_NUMBER.CANONICAL_TO_NUMBER(remove_curr_format(get_24Q_values('IN_24Q_VIA','80CCE',pai.action_context_id,pai.source_id,1)))
2058: <> FND_NUMBER.CANONICAL_TO_NUMBER(remove_curr_format(pay_in_tax_utils.get_balance_value(pai.source_id,'F16 Deductions Sec 80CCE','_ASG_LE_PTD','TAX_UNIT_ID',g_gre_id))))
2059: OR
2060: (pai.action_information6 <> hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title))
2061: OR -- Checking PAN reference Number
2062: (NVL(pai.action_information5,'0') <> NVL(pep.per_information14,'0'))
2063: OR ( --Checking PAN Number
2064: (

Line 2240: (pai.action_information6 <> hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title))

2236: OR
2237: (FND_NUMBER.CANONICAL_TO_NUMBER(remove_curr_format(get_24Q_values('IN_24QC_VIA','80CCE',pai.action_context_id,pai.source_id,1)))
2238: <> FND_NUMBER.CANONICAL_TO_NUMBER(remove_curr_format(pay_in_tax_utils.get_balance_value(pai.source_id,'F16 Deductions Sec 80CCE','_ASG_LE_PTD','TAX_UNIT_ID',g_gre_id))))
2239: OR
2240: (pai.action_information6 <> hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title))
2241: OR
2242: (NVL(pai.action_information5,'0') <> NVL(pep.per_information14,'0'))
2243: OR(
2244: (

Line 2340: (pai.action_information6 = hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title))

2336: AND
2337: (FND_NUMBER.CANONICAL_TO_NUMBER(remove_curr_format(get_24Q_values('IN_24QC_VIA','80CCE',pai.action_context_id,pai.source_id,1)))
2338: = FND_NUMBER.CANONICAL_TO_NUMBER(remove_curr_format(pay_in_tax_utils.get_balance_value(pai.source_id,'F16 Deductions Sec 80CCE','_ASG_LE_PTD','TAX_UNIT_ID',g_gre_id))))
2339: AND
2340: (pai.action_information6 = hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title))
2341: AND(--Checking PAN Number
2342: (
2343: g_correction_mode IN ('C5','%')
2344: AND (pai.action_information4 NOT IN('APPLIEDFOR','PANNOTAVBL'))

Line 2779: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) rep_name

2775:
2776: CURSOR c_representative_id
2777: IS
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

Line 3884: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) full_name

3880: IS
3881: SELECT asg.person_id person_id
3882: ,DECODE(pep.per_information4,NULL,DECODE(pep.per_information5,'Yes','APPLIEDFOR','PANNOTAVBL'),pep.per_information4) pan
3883: ,pep.per_information14 pan_ref_number
3884: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) full_name
3885: ,pep.effective_end_date
3886: FROM per_assignments_f asg
3887: ,per_people_f pep
3888: WHERE asg.assignment_id = p_assignment_id

Line 4303: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) full_name

4299: IS
4300: SELECT asg.person_id person_id
4301: ,DECODE(pep.per_information4,NULL,DECODE(pep.per_information5,'Yes','APPLIEDFOR','PANNOTAVBL'),pep.per_information4) pan
4302: ,pep.per_information14 pan_ref_number
4303: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) full_name
4304: FROM per_assignments_f asg
4305: ,per_people_f pep
4306: WHERE asg.assignment_id = p_assignment_id
4307: AND pep.person_id = asg.person_id