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_CHECK_PVT dependencies on PA_MULTI_CURRENCY_BILLING

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

2032: AND brs.job_group_id = pt.bill_job_group_id
2033: and brs.schedule_type = 'JOB'
2034: AND pa.project_type = pt.project_type
2035: AND pa.org_id = pt.org_id --added for Bug 5675391
2036: AND ( pa.multi_currency_BILLING_flag = 'Y'
2037: OR (pa.multi_currency_billing_flag = 'N'
2038: AND brs.rate_sch_currency_code = pa.projfunc_currency_code))
2039: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
2040: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'N'

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

2033: and brs.schedule_type = 'JOB'
2034: AND pa.project_type = pt.project_type
2035: AND pa.org_id = pt.org_id --added for Bug 5675391
2036: AND ( pa.multi_currency_BILLING_flag = 'Y'
2037: OR (pa.multi_currency_billing_flag = 'N'
2038: AND brs.rate_sch_currency_code = pa.projfunc_currency_code))
2039: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
2040: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'N'
2041: and brs.org_id = pa.org_id))

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

2035: AND pa.org_id = pt.org_id --added for Bug 5675391
2036: AND ( pa.multi_currency_BILLING_flag = 'Y'
2037: OR (pa.multi_currency_billing_flag = 'N'
2038: AND brs.rate_sch_currency_code = pa.projfunc_currency_code))
2039: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
2040: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'N'
2041: and brs.org_id = pa.org_id))
2042: and (brs.share_across_ou_flag = 'Y'
2043: OR (brs.share_across_ou_flag = 'N'

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

2036: AND ( pa.multi_currency_BILLING_flag = 'Y'
2037: OR (pa.multi_currency_billing_flag = 'N'
2038: AND brs.rate_sch_currency_code = pa.projfunc_currency_code))
2039: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
2040: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'N'
2041: and brs.org_id = pa.org_id))
2042: and (brs.share_across_ou_flag = 'Y'
2043: OR (brs.share_across_ou_flag = 'N'
2044: and brs.org_id = pa.org_id

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

2050: FROM pa_std_bill_rate_schedules_all brs, pa_projects pa
2051: WHERE brs.bill_rate_sch_id = l_emp_rate_schdid
2052: AND pa.project_id = l_project_id
2053: and brs.schedule_type = 'EMPLOYEE'
2054: AND ( pa.multi_currency_BILLING_flag = 'Y'
2055: OR (pa.multi_currency_billing_flag='N'
2056: AND brs.rate_sch_currency_code = pa.projfunc_currency_code))
2057: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
2058: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'N'

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

2051: WHERE brs.bill_rate_sch_id = l_emp_rate_schdid
2052: AND pa.project_id = l_project_id
2053: and brs.schedule_type = 'EMPLOYEE'
2054: AND ( pa.multi_currency_BILLING_flag = 'Y'
2055: OR (pa.multi_currency_billing_flag='N'
2056: AND brs.rate_sch_currency_code = pa.projfunc_currency_code))
2057: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
2058: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'N'
2059: and brs.org_id = pa.org_id))

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

2053: and brs.schedule_type = 'EMPLOYEE'
2054: AND ( pa.multi_currency_BILLING_flag = 'Y'
2055: OR (pa.multi_currency_billing_flag='N'
2056: AND brs.rate_sch_currency_code = pa.projfunc_currency_code))
2057: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
2058: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'N'
2059: and brs.org_id = pa.org_id))
2060: and (brs.share_across_ou_flag = 'Y'
2061: OR (brs.share_across_ou_flag = 'N'

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

2054: AND ( pa.multi_currency_BILLING_flag = 'Y'
2055: OR (pa.multi_currency_billing_flag='N'
2056: AND brs.rate_sch_currency_code = pa.projfunc_currency_code))
2057: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
2058: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'N'
2059: and brs.org_id = pa.org_id))
2060: and (brs.share_across_ou_flag = 'Y'
2061: OR (brs.share_across_ou_flag = 'N'
2062: and brs.org_id = pa.org_id