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.PA_PROJECT_PVT dependencies on PA_MULTI_CURRENCY_BILLING

Line 11336: AND ( pa.multi_currency_BILLING_flag='Y'

11332: FROM pa_std_bill_rate_schedules_all brs, pa_projects pa
11333: WHERE brs.bill_rate_sch_id = p_emp_bill_rate_schedule_id
11334: AND pa.project_id=p_pa_project_id
11335: and brs.schedule_type = 'EMPLOYEE'
11336: AND ( pa.multi_currency_BILLING_flag='Y'
11337: OR (pa.multi_currency_billing_flag='N'
11338: AND brs.rate_sch_currency_code=pa.project_currency_code))
11339: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
11340: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'

Line 11337: OR (pa.multi_currency_billing_flag='N'

11333: WHERE brs.bill_rate_sch_id = p_emp_bill_rate_schedule_id
11334: AND pa.project_id=p_pa_project_id
11335: and brs.schedule_type = 'EMPLOYEE'
11336: AND ( pa.multi_currency_BILLING_flag='Y'
11337: OR (pa.multi_currency_billing_flag='N'
11338: AND brs.rate_sch_currency_code=pa.project_currency_code))
11339: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
11340: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'
11341: and brs.org_id=pa.org_id))

Line 11339: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')

11335: and brs.schedule_type = 'EMPLOYEE'
11336: AND ( pa.multi_currency_BILLING_flag='Y'
11337: OR (pa.multi_currency_billing_flag='N'
11338: AND brs.rate_sch_currency_code=pa.project_currency_code))
11339: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
11340: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'
11341: and brs.org_id=pa.org_id))
11342: and (brs.share_across_ou_flag = 'Y'
11343: OR (brs.share_across_ou_flag = 'N'

Line 11340: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'

11336: AND ( pa.multi_currency_BILLING_flag='Y'
11337: OR (pa.multi_currency_billing_flag='N'
11338: AND brs.rate_sch_currency_code=pa.project_currency_code))
11339: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
11340: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'
11341: and brs.org_id=pa.org_id))
11342: and (brs.share_across_ou_flag = 'Y'
11343: OR (brs.share_across_ou_flag = 'N'
11344: and brs.org_id = pa.org_id

Line 11357: AND ( pa.multi_currency_BILLING_flag='Y'

11353: AND brs.job_group_id=pt.bill_job_group_id
11354: and brs.schedule_type = 'JOB'
11355: AND pa.project_type=pt.project_type
11356: AND pa.org_id = pt.org_id -- added for Bug 5675391
11357: AND ( pa.multi_currency_BILLING_flag='Y'
11358: OR (pa.multi_currency_billing_flag='N'
11359: AND brs.rate_sch_currency_code=pa.project_currency_code))
11360: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
11361: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'

Line 11358: OR (pa.multi_currency_billing_flag='N'

11354: and brs.schedule_type = 'JOB'
11355: AND pa.project_type=pt.project_type
11356: AND pa.org_id = pt.org_id -- added for Bug 5675391
11357: AND ( pa.multi_currency_BILLING_flag='Y'
11358: OR (pa.multi_currency_billing_flag='N'
11359: AND brs.rate_sch_currency_code=pa.project_currency_code))
11360: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
11361: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'
11362: and brs.org_id=pa.org_id))

Line 11360: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')

11356: AND pa.org_id = pt.org_id -- added for Bug 5675391
11357: AND ( pa.multi_currency_BILLING_flag='Y'
11358: OR (pa.multi_currency_billing_flag='N'
11359: AND brs.rate_sch_currency_code=pa.project_currency_code))
11360: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
11361: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'
11362: and brs.org_id=pa.org_id))
11363: and (brs.share_across_ou_flag = 'Y'
11364: OR (brs.share_across_ou_flag = 'N'

Line 11361: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'

11357: AND ( pa.multi_currency_BILLING_flag='Y'
11358: OR (pa.multi_currency_billing_flag='N'
11359: AND brs.rate_sch_currency_code=pa.project_currency_code))
11360: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
11361: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'
11362: and brs.org_id=pa.org_id))
11363: and (brs.share_across_ou_flag = 'Y'
11364: OR (brs.share_across_ou_flag = 'N'
11365: and brs.org_id = pa.org_id

Line 11380: AND ( pa.multi_currency_BILLING_flag='Y'

11376: and brs.schedule_type = 'NON-LABOR'
11377: and (brs.schedule_type <> 'JOB'
11378: or (brs.schedule_type = 'JOB'
11379: and brs.job_group_id = pa.bill_job_group_id))
11380: AND ( pa.multi_currency_BILLING_flag='Y'
11381: OR (pa.multi_currency_billing_flag='N'
11382: AND brs.rate_sch_currency_code=pa.project_currency_code))
11383: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
11384: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'

Line 11381: OR (pa.multi_currency_billing_flag='N'

11377: and (brs.schedule_type <> 'JOB'
11378: or (brs.schedule_type = 'JOB'
11379: and brs.job_group_id = pa.bill_job_group_id))
11380: AND ( pa.multi_currency_BILLING_flag='Y'
11381: OR (pa.multi_currency_billing_flag='N'
11382: AND brs.rate_sch_currency_code=pa.project_currency_code))
11383: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
11384: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'
11385: and brs.org_id=pa.org_id))

Line 11383: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')

11379: and brs.job_group_id = pa.bill_job_group_id))
11380: AND ( pa.multi_currency_BILLING_flag='Y'
11381: OR (pa.multi_currency_billing_flag='N'
11382: AND brs.rate_sch_currency_code=pa.project_currency_code))
11383: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
11384: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'
11385: and brs.org_id=pa.org_id))
11386: and (brs.share_across_ou_flag = 'Y'
11387: OR (brs.share_across_ou_flag = 'N'

Line 11384: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'

11380: AND ( pa.multi_currency_BILLING_flag='Y'
11381: OR (pa.multi_currency_billing_flag='N'
11382: AND brs.rate_sch_currency_code=pa.project_currency_code))
11383: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
11384: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'
11385: and brs.org_id=pa.org_id))
11386: and (brs.share_across_ou_flag = 'Y'
11387: OR (brs.share_across_ou_flag = 'N'
11388: and brs.org_id = pa.org_id