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.PSP_LABOR_DIST dependencies on FND_NUMBER

Line 7123: fnd_number.number_to_canonical(cap_rec.daily_cap_rate)||', '||g_precision||') capped_schedule_amount,

7119: 'Select pdl.distribution_line_id,
7120: pdl.distribution_date,
7121: pdl.distribution_amount,
7122: round(nvl(psl.schedule_percent, nvl(pdls.schedule_percent, nvl(pea.percent, (100 * pdl.distribution_amount)/ppsl.daily_rate )))/100 * '||
7123: fnd_number.number_to_canonical(cap_rec.daily_cap_rate)||', '||g_precision||') capped_schedule_amount,
7124: ppl.assignment_id,
7125: null excess_account_id,
7126: null excess_line_id
7127: bulk collect

Line 7158: and ppsl.daily_rate > '||fnd_number.number_to_canonical(cap_rec.daily_cap_rate)||' -- Bug 8672063

7154: and pdl.distribution_amount <> 0
7155: and ppc.payroll_control_id = '||p_payroll_control_id||'
7156: and ppc.business_group_id = '||p_business_group_id||'
7157: and ppc.set_of_books_id = '||p_set_of_books_id||'
7158: and ppsl.daily_rate > '||fnd_number.number_to_canonical(cap_rec.daily_cap_rate)||' -- Bug 8672063
7159: and ppl.dr_cr_flag = '||''''||'D'||''''||'
7160: and ppl.assignment_id between '||p_start_asg_id||' and '||p_end_asg_id||'
7161: and pdl.cap_excess_dist_line_id is null
7162: and pdl.distribution_date between '||''''||cap_rec.start_date||''''||' and '||''''||cap_rec.end_date||''''||'

Line 7177: fnd_number.number_to_canonical(cap_rec.daily_cap_rate)||', '||g_precision||') capped_schedule_amount,

7173: ' select pdl.distribution_line_id,
7174: pdl.distribution_date,
7175: pdl.distribution_amount,
7176: round(nvl(psl.schedule_percent, nvl(pdls.schedule_percent, nvl(pea.percent, (100 * pdl.distribution_amount)/ppsl.daily_rate )))/100 * '||
7177: fnd_number.number_to_canonical(cap_rec.daily_cap_rate)||', '||g_precision||') capped_schedule_amount,
7178: ppl.assignment_id,
7179: null excess_account_id,
7180: null excess_line_id
7181: bulk collect

Line 7212: and ppsl.daily_rate > '||fnd_number.number_to_canonical(cap_rec.daily_cap_rate)||' -- Bug 8672063

7208: AND pdl.distribution_amount <> 0
7209: and ppc.payroll_control_id = '||p_payroll_control_id||'
7210: and ppc.business_group_id = '||p_business_group_id||'
7211: and ppc.set_of_books_id = '||p_set_of_books_id||'
7212: and ppsl.daily_rate > '||fnd_number.number_to_canonical(cap_rec.daily_cap_rate)||' -- Bug 8672063
7213: AND ppl.dr_cr_flag = '||''''||'D'||''''||'
7214: and pdl.cap_excess_dist_line_id is null
7215: and pdl.distribution_date between '||''''||cap_rec.start_date||''''||' and '||''''||cap_rec.end_date||''''||'
7216: and ppl.assignment_id between '||p_start_asg_id||' and '||p_end_asg_id||'