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_REVENUE dependencies on PA_CROSS_BUSINESS_GRP

Line 1638: AND j.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Added for bug 3193077 */

1634: AND p_item_date
1635: BETWEEN j.start_date_active
1636: AND NVL(j.end_date_active,p_item_date)
1637: /* AND j.job_id = a.job_id commented for bug 3193077 */
1638: AND j.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Added for bug 3193077 */
1639: --AND a.person_id = p_person_id /* Commented for Bug 6058676*/
1640: --AND a.primary_flag || '' = 'Y'
1641: -- AND a.assignment_type = 'E' /* bug 2911451 */
1642: --AND a.assignment_type IN ('E','C') -- Modified for CWK changes /* Commented for Bug 6058676*/

Line 1675: AND j.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 / /bug3737994*/

1671: l_amount_calculation_code,
1672: l_discount_percentage
1673: FROM pa_job_bill_rate_overrides j
1674: WHERE j.task_id = p_task_id
1675: AND j.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 */ /*bug3737994*/
1676: AND p_item_date
1677: BETWEEN j.start_date_active
1678: AND NVL(j.end_date_active,p_item_date)
1679: AND l_called_process <>1; /*Added for Doosan rate api change */

Line 1721: AND j.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id);

1717: WHERE j.project_id = p_project_id -- + (0 * a.person_id)
1718: AND p_item_date + 0.99999
1719: BETWEEN j.start_date_active
1720: AND NVL(j.end_date_active + 0.99999,p_item_date + 0.99999)
1721: AND j.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id);
1722: --AND a.person_id = p_person_id
1723: --AND a.primary_flag = 'Y'
1724: -- AND a.assignment_type = 'E' /* bug 2911451 */
1725: --AND a.assignment_type IN ('E','C') -- Modified for CWK changes

Line 1758: AND j.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) ;--pa_cross_business_grp.IsmappedTojob(a.job_id,l_bill_job_grp_id) /* Bug 6058676 */

1754: WHERE j.project_id = p_project_id --+ (0 * a.person_id)
1755: AND p_item_date + 0.99999
1756: BETWEEN j.start_date_active
1757: AND NVL(j.end_date_active + 0.99999,p_item_date + 0.99999)
1758: AND j.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) ;--pa_cross_business_grp.IsmappedTojob(a.job_id,l_bill_job_grp_id) /* Bug 6058676 */
1759: -- AND a.person_id = p_person_id
1760: -- AND a.primary_flag = 'Y'
1761: -- AND a.assignment_type = 'E' /* bug 2911451 */
1762: -- AND a.assignment_type IN ('E','C') -- Modified for CWK changes

Line 2012: AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 */

2008: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao
2009: WHERE ao.person_id = p_person_id
2010: AND b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2011: AND b.job_id = ao.job_id(+)
2012: AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 */
2013: AND p_task_id = ao.task_id
2014: AND l_called_process <>1 /*Added for Doosan rate api change */
2015: AND p_item_date
2016: BETWEEN ao.start_date_active

Line 2059: AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 */

2055: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao, pa_tasks t
2056: WHERE ao.person_id = p_person_id
2057: AND b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2058: AND b.job_id = ao.job_id(+)
2059: AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 */
2060: AND t.project_id = ao.project_id
2061: AND t.task_id = p_task_id
2062: AND l_called_process <>2 /*Added for Doosan rate api change */
2063: AND p_item_date

Line 2157: AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Changed the join instead of joining with p_resource_job_id, now joining using function IsmappedTojob to fix bug 2155331 / / Bug 6058676 */

2153: AND pa.assignment_type IN ('E','C') -- Modified for CWK changes
2154: AND p_item_date /* BUG#3118592 */
2155: BETWEEN pa.effective_start_date
2156: AND pa.effective_end_date
2157: AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Changed the join instead of joining with p_resource_job_id, now joining using function IsmappedTojob to fix bug 2155331 */ /* Bug 6058676 */
2158: AND NVL(l_labor_schdl_fixed_date,p_item_date)
2159: BETWEEN b.start_date_active
2160: AND NVL(b.end_date_active,
2161: NVL(l_labor_schdl_fixed_date,p_item_date));

Line 2190: AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 */

2186: l_amount_calculation_code,
2187: l_discount_percentage
2188: FROM pa_bill_rates_all b
2189: WHERE b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2190: AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 */
2191: AND NVL(l_labor_schdl_fixed_date,p_item_date)
2192: BETWEEN b.start_date_active
2193: AND NVL(b.end_date_active,
2194: NVL(l_labor_schdl_fixed_date,p_item_date));

Line 2249: AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id)

2245: l_rate_currency_code
2246: l_markup_percentage
2247: FROM pa_bill_rates_all b
2248: WHERE b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2249: AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id)
2250: AND NVL(l_labor_schdl_fixed_date,p_item_date)
2251: BETWEEN b.start_date_active
2252: AND NVL(b.end_date_active,
2253: NVL(l_labor_schdl_fixed_date,p_item_date))