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 325: AND ( pbt.legislation_code = 'IN' OR pbt.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))

321: ,pay_balance_dimensions pbd
322: WHERE pbt.balance_name = p_balance_type
323: AND pbd.dimension_name = p_dimension_name
324: AND pdb.balance_type_id = pbt.balance_type_id
325: AND ( pbt.legislation_code = 'IN' OR pbt.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
326: AND ( pbd.legislation_code = 'IN' OR pbd.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
327: AND ( pdb.legislation_code = 'IN' OR pdb.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
328: AND pdb.balance_dimension_id = pbd.balance_dimension_id;
329:

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

322: WHERE pbt.balance_name = p_balance_type
323: AND pbd.dimension_name = p_dimension_name
324: AND pdb.balance_type_id = pbt.balance_type_id
325: AND ( pbt.legislation_code = 'IN' OR pbt.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
326: AND ( pbd.legislation_code = 'IN' OR pbd.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
327: AND ( pdb.legislation_code = 'IN' OR pdb.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
328: AND pdb.balance_dimension_id = pbd.balance_dimension_id;
329:
330: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

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

323: AND pbd.dimension_name = p_dimension_name
324: AND pdb.balance_type_id = pbt.balance_type_id
325: AND ( pbt.legislation_code = 'IN' OR pbt.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
326: AND ( pbd.legislation_code = 'IN' OR pbd.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
327: AND ( pdb.legislation_code = 'IN' OR pdb.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
328: AND pdb.balance_dimension_id = pbd.balance_dimension_id;
329:
330: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
331: l_message VARCHAR2(255);

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

501: per_assignments_f asg -- Added to remove NMV as per bug 4774108
502: where ppa.payroll_Action_id = paa.payroll_Action_id
503: and paa.assignment_id = p_assignment_id
504: and paa.assignment_id = asg.assignment_id-- Added to remove NMV as per bug 4774108
505: and asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
506: and ppa.action_type in ('B','V','I','R','Q')
507: -- and paa.source_action_id is not null -- Commented for bug 4774514
508: and ppa.date_earned between p_year_start and p_year_end
509: and ppa.date_earned between asg.effective_start_date and asg.effective_end_date