APPS.PA_REVENUE dependencies on PA_LABOR_MULTIPLIERS

Line 1820: FROM pa_labor_multipliers m

1816: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
1817: (m.labor_multiplier * decode(p_mcb_flag,'Y',l_mcb_raw_cost,p_raw_cost)),
1818: decode(p_mcb_flag,'Y',l_mcb_currency_code,l_projfunc_currency_code)) r_revenue,
1819: decode(p_mcb_flag,'Y',l_mcb_currency_code,l_projfunc_currency_code) curr_code
1820: FROM pa_labor_multipliers m
1821: WHERE m.task_id = p_task_id
1822: AND l_called_process <>1 /*Added for Doosan rate api change */
1823: AND p_item_date
1824: BETWEEN m.start_date_active

Line 1832: FROM pa_labor_multipliers m2

1828: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
1829: (m2.labor_multiplier * decode(p_mcb_flag,'Y',l_mcb_raw_cost,p_raw_cost)),
1830: decode(p_mcb_flag,'Y',l_mcb_currency_code,l_projfunc_currency_code)) r_revenue,
1831: decode(p_mcb_flag,'Y',l_mcb_currency_code,l_projfunc_currency_code) curr_code
1832: FROM pa_labor_multipliers m2
1833: WHERE m2.project_id = p_project_id
1834: AND l_called_process <>2 /*Added for Doosan rate api change */
1835: AND p_item_date
1836: BETWEEN m2.start_date_active

Line 1840: FROM pa_labor_multipliers m3

1836: BETWEEN m2.start_date_active
1837: AND NVL(m2.end_date_active,p_item_date)
1838: AND NOT EXISTS
1839: ( SELECT NULL
1840: FROM pa_labor_multipliers m3
1841: WHERE m3.task_id = p_task_id
1842: AND l_called_process <>1 /*Added for Doosan rate api change */
1843: AND p_item_date
1844: BETWEEN m3.start_date_active