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.

[Home] [Help]

APPS.PAY_IN_24QC_ARCHIVE dependencies on HR_IN_UTILITY

Line 1208: (pai.action_information12 <> 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_information12 <> hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title))
1209: OR
1210: (NVL(pai.action_information11,'0') <> NVL(pep.per_information14,'0'))
1211: OR(
1212: (

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

1311: (TO_NUMBER(remove_curr_format(pai.action_information5)) <> TO_NUMBER(remove_curr_format(pay_in_utils.get_ee_value(pai.source_id,'Taxable Income'))))
1312: OR
1313: (pai.action_information4 <> pay_in_utils.get_ee_value(pai.source_id,'Payment Date'))
1314: OR
1315: (pai.action_information10 <> hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title))
1316: OR(--Checking PAN Number
1317: (
1318: g_correction_mode IN ('C5','%')
1319: AND (pai.action_information9 NOT IN('APPLIEDFOR','PANNOTAVBL'))

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

1368: (TO_NUMBER(remove_curr_format(pai.action_information5)) = TO_NUMBER(remove_curr_format(pay_in_utils.get_ee_value(pai.source_id,'Taxable Income'))))
1369: AND
1370: (pai.action_information4 = pay_in_utils.get_ee_value(pai.source_id,'Payment Date'))
1371: AND
1372: (pai.action_information10 = hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title))
1373: AND(--Checking PAN Number
1374: (
1375: g_correction_mode IN ('C5','%')
1376: AND (pai.action_information9 NOT IN('APPLIEDFOR','PANNOTAVBL'))

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

2163: OR
2164: (FND_NUMBER.CANONICAL_TO_NUMBER(remove_curr_format(get_24Q_values('IN_24Q_VIA','80CCE',pai.action_context_id,pai.source_id,1)))
2165: <> 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))))
2166: OR
2167: (pai.action_information6 <> hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title))
2168: OR -- Checking PAN reference Number
2169: (NVL(pai.action_information5,'0') <> NVL(pep.per_information14,'0'))
2170: OR ( --Checking PAN Number
2171: (

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

2343: OR
2344: (FND_NUMBER.CANONICAL_TO_NUMBER(remove_curr_format(get_24Q_values('IN_24QC_VIA','80CCE',pai.action_context_id,pai.source_id,1)))
2345: <> 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))))
2346: OR
2347: (pai.action_information6 <> hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title))
2348: OR
2349: (NVL(pai.action_information5,'0') <> NVL(pep.per_information14,'0'))
2350: OR(
2351: (

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

2443: AND
2444: (FND_NUMBER.CANONICAL_TO_NUMBER(remove_curr_format(get_24Q_values('IN_24QC_VIA','80CCE',pai.action_context_id,pai.source_id,1)))
2445: = 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))))
2446: AND
2447: (pai.action_information6 = hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title))
2448: AND(--Checking PAN Number
2449: (
2450: g_correction_mode IN ('C5','%')
2451: AND (pai.action_information4 NOT IN('APPLIEDFOR','PANNOTAVBL'))

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

2897:
2898: CURSOR c_representative_id
2899: IS
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

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

4204: IS
4205: SELECT asg.person_id person_id
4206: ,DECODE(pep.per_information4,NULL,DECODE(pep.per_information5,'Yes','APPLIEDFOR','PANNOTAVBL'),pep.per_information4) pan
4207: ,pep.per_information14 pan_ref_number
4208: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) full_name
4209: ,pep.effective_end_date
4210: FROM per_assignments_f asg
4211: ,per_people_f pep
4212: WHERE asg.assignment_id = p_assignment_id

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

4623: IS
4624: SELECT asg.person_id person_id
4625: ,DECODE(pep.per_information4,NULL,DECODE(pep.per_information5,'Yes','APPLIEDFOR','PANNOTAVBL'),pep.per_information4) pan
4626: ,pep.per_information14 pan_ref_number
4627: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) full_name
4628: FROM per_assignments_f asg
4629: ,per_people_f pep
4630: WHERE asg.assignment_id = p_assignment_id
4631: AND pep.person_id = asg.person_id