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 10986: AND ( pa.multi_currency_BILLING_flag='Y'

10982: FROM pa_std_bill_rate_schedules_all brs, pa_projects pa
10983: WHERE brs.bill_rate_sch_id = p_emp_bill_rate_schedule_id
10984: AND pa.project_id=p_pa_project_id
10985: and brs.schedule_type = 'EMPLOYEE'
10986: AND ( pa.multi_currency_BILLING_flag='Y'
10987: OR (pa.multi_currency_billing_flag='N'
10988: AND brs.rate_sch_currency_code=pa.project_currency_code))
10989: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
10990: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'

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

10983: WHERE brs.bill_rate_sch_id = p_emp_bill_rate_schedule_id
10984: AND pa.project_id=p_pa_project_id
10985: and brs.schedule_type = 'EMPLOYEE'
10986: AND ( pa.multi_currency_BILLING_flag='Y'
10987: OR (pa.multi_currency_billing_flag='N'
10988: AND brs.rate_sch_currency_code=pa.project_currency_code))
10989: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
10990: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'
10991: and brs.org_id=pa.org_id))

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

10985: and brs.schedule_type = 'EMPLOYEE'
10986: AND ( pa.multi_currency_BILLING_flag='Y'
10987: OR (pa.multi_currency_billing_flag='N'
10988: AND brs.rate_sch_currency_code=pa.project_currency_code))
10989: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
10990: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'
10991: and brs.org_id=pa.org_id))
10992: and (brs.share_across_ou_flag = 'Y'
10993: OR (brs.share_across_ou_flag = 'N'

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

10986: AND ( pa.multi_currency_BILLING_flag='Y'
10987: OR (pa.multi_currency_billing_flag='N'
10988: AND brs.rate_sch_currency_code=pa.project_currency_code))
10989: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
10990: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'
10991: and brs.org_id=pa.org_id))
10992: and (brs.share_across_ou_flag = 'Y'
10993: OR (brs.share_across_ou_flag = 'N'
10994: and brs.org_id = pa.org_id

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

11003: AND brs.job_group_id=pt.bill_job_group_id
11004: and brs.schedule_type = 'JOB'
11005: AND pa.project_type=pt.project_type
11006: AND pa.org_id = pt.org_id -- added for Bug 5675391
11007: AND ( pa.multi_currency_BILLING_flag='Y'
11008: OR (pa.multi_currency_billing_flag='N'
11009: AND brs.rate_sch_currency_code=pa.project_currency_code))
11010: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
11011: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'

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

11004: and brs.schedule_type = 'JOB'
11005: AND pa.project_type=pt.project_type
11006: AND pa.org_id = pt.org_id -- added for Bug 5675391
11007: AND ( pa.multi_currency_BILLING_flag='Y'
11008: OR (pa.multi_currency_billing_flag='N'
11009: AND brs.rate_sch_currency_code=pa.project_currency_code))
11010: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
11011: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'
11012: and brs.org_id=pa.org_id))

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

11006: AND pa.org_id = pt.org_id -- added for Bug 5675391
11007: AND ( pa.multi_currency_BILLING_flag='Y'
11008: OR (pa.multi_currency_billing_flag='N'
11009: AND brs.rate_sch_currency_code=pa.project_currency_code))
11010: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
11011: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'
11012: and brs.org_id=pa.org_id))
11013: and (brs.share_across_ou_flag = 'Y'
11014: OR (brs.share_across_ou_flag = 'N'

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

11007: AND ( pa.multi_currency_BILLING_flag='Y'
11008: OR (pa.multi_currency_billing_flag='N'
11009: AND brs.rate_sch_currency_code=pa.project_currency_code))
11010: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
11011: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'
11012: and brs.org_id=pa.org_id))
11013: and (brs.share_across_ou_flag = 'Y'
11014: OR (brs.share_across_ou_flag = 'N'
11015: and brs.org_id = pa.org_id

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

11026: and brs.schedule_type = 'NON-LABOR'
11027: and (brs.schedule_type <> 'JOB'
11028: or (brs.schedule_type = 'JOB'
11029: and brs.job_group_id = pa.bill_job_group_id))
11030: AND ( pa.multi_currency_BILLING_flag='Y'
11031: OR (pa.multi_currency_billing_flag='N'
11032: AND brs.rate_sch_currency_code=pa.project_currency_code))
11033: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
11034: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'

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

11027: and (brs.schedule_type <> 'JOB'
11028: or (brs.schedule_type = 'JOB'
11029: and brs.job_group_id = pa.bill_job_group_id))
11030: AND ( pa.multi_currency_BILLING_flag='Y'
11031: OR (pa.multi_currency_billing_flag='N'
11032: AND brs.rate_sch_currency_code=pa.project_currency_code))
11033: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
11034: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'
11035: and brs.org_id=pa.org_id))

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

11029: and brs.job_group_id = pa.bill_job_group_id))
11030: AND ( pa.multi_currency_BILLING_flag='Y'
11031: OR (pa.multi_currency_billing_flag='N'
11032: AND brs.rate_sch_currency_code=pa.project_currency_code))
11033: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
11034: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'
11035: and brs.org_id=pa.org_id))
11036: and (brs.share_across_ou_flag = 'Y'
11037: OR (brs.share_across_ou_flag = 'N'

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

11030: AND ( pa.multi_currency_BILLING_flag='Y'
11031: OR (pa.multi_currency_billing_flag='N'
11032: AND brs.rate_sch_currency_code=pa.project_currency_code))
11033: AND ((pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id) = 'Y')
11034: or (pa_multi_currency_billing.is_sharing_bill_rates_allowed(pa.org_id)='N'
11035: and brs.org_id=pa.org_id))
11036: and (brs.share_across_ou_flag = 'Y'
11037: OR (brs.share_across_ou_flag = 'N'
11038: and brs.org_id = pa.org_id