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_TAX_UTILS dependencies on FND_PROFILE

Line 453: AND ( pbt.legislation_code = 'IN' OR pbt.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))

449: ,pay_balance_dimensions pbd
450: WHERE pbt.balance_name = p_balance_type
451: AND pbd.dimension_name = p_dimension_name
452: AND pdb.balance_type_id = pbt.balance_type_id
453: AND ( pbt.legislation_code = 'IN' OR pbt.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
454: AND ( pbd.legislation_code = 'IN' OR pbd.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
455: AND ( pdb.legislation_code = 'IN' OR pdb.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
456: AND pdb.balance_dimension_id = pbd.balance_dimension_id;
457:

Line 454: AND ( pbd.legislation_code = 'IN' OR pbd.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))

450: WHERE pbt.balance_name = p_balance_type
451: AND pbd.dimension_name = p_dimension_name
452: AND pdb.balance_type_id = pbt.balance_type_id
453: AND ( pbt.legislation_code = 'IN' OR pbt.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
454: AND ( pbd.legislation_code = 'IN' OR pbd.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
455: AND ( pdb.legislation_code = 'IN' OR pdb.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
456: AND pdb.balance_dimension_id = pbd.balance_dimension_id;
457:
458: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

Line 455: AND ( pdb.legislation_code = 'IN' OR pdb.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))

451: AND pbd.dimension_name = p_dimension_name
452: AND pdb.balance_type_id = pbt.balance_type_id
453: AND ( pbt.legislation_code = 'IN' OR pbt.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
454: AND ( pbd.legislation_code = 'IN' OR pbd.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
455: AND ( pdb.legislation_code = 'IN' OR pdb.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
456: AND pdb.balance_dimension_id = pbd.balance_dimension_id;
457:
458: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
459: l_message VARCHAR2(255);

Line 816: and asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

812: per_assignments_f asg -- Added to remove NMV as per bug 4774108
813: where ppa.payroll_Action_id = paa.payroll_Action_id
814: and paa.assignment_id = p_assignment_id
815: and paa.assignment_id = asg.assignment_id-- Added to remove NMV as per bug 4774108
816: and asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
817: and ppa.action_type in ('B','V','I','R','Q')
818: -- and paa.source_action_id is not null -- Commented for bug 4774514
819: and ppa.date_earned between p_year_start and p_year_end
820: and ppa.date_earned between asg.effective_start_date and asg.effective_end_date