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 1657: AND j.job_id = pa_cross_business_grp.IsmappedTojob(a.job_id,l_bill_job_grp_id) /* Added for bug 3193077 */

1653: AND p_item_date
1654: BETWEEN j.start_date_active
1655: AND NVL(j.end_date_active,p_item_date)
1656: /* AND j.job_id = a.job_id commented for bug 3193077 */
1657: AND j.job_id = pa_cross_business_grp.IsmappedTojob(a.job_id,l_bill_job_grp_id) /* Added for bug 3193077 */
1658: AND a.person_id = p_person_id /* Commented for Bug 6058676*//*uncommented for bug 9257637 */
1659: AND a.primary_flag || '' = 'Y'
1660: -- AND a.assignment_type = 'E' /* bug 2911451 */
1661: AND a.assignment_type IN ('E','C') -- Modified for CWK changes /* Commented for Bug 6058676*//*uncommented for bug 9257637 */

Line 1740: AND j.job_id = pa_cross_business_grp.IsmappedTojob(a.job_id,l_bill_job_grp_id)

1736: WHERE j.project_id = p_project_id + (0 * a.person_id)
1737: AND p_item_date + 0.99999
1738: BETWEEN j.start_date_active
1739: AND NVL(j.end_date_active + 0.99999,p_item_date + 0.99999)
1740: AND j.job_id = pa_cross_business_grp.IsmappedTojob(a.job_id,l_bill_job_grp_id)
1741: AND a.person_id = p_person_id
1742: AND a.primary_flag = 'Y'
1743: -- AND a.assignment_type = 'E' /* bug 2911451 */
1744: AND a.assignment_type IN ('E','C') -- Modified for CWK changes

Line 1777: AND j.job_id = p_resource_job_id;--pa_cross_business_grp.IsmappedTojob(a.job_id,l_bill_job_grp_id) /* Bug 6058676 //modified for bug 9257637 */

1773: WHERE j.project_id = p_project_id --+ (0 * a.person_id)
1774: AND p_item_date + 0.99999
1775: BETWEEN j.start_date_active
1776: AND NVL(j.end_date_active + 0.99999,p_item_date + 0.99999)
1777: AND j.job_id = p_resource_job_id;--pa_cross_business_grp.IsmappedTojob(a.job_id,l_bill_job_grp_id) /* Bug 6058676 *//*modified for bug 9257637 */
1778: -- AND a.person_id = p_person_id
1779: -- AND a.primary_flag = 'Y'
1780: -- AND a.assignment_type = 'E' /* bug 2911451 */
1781: -- AND a.assignment_type IN ('E','C') -- Modified for CWK changes

Line 2031: -- AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 //commented for bug 9257637 */

2027: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao
2028: WHERE ao.person_id = p_person_id
2029: AND b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2030: AND b.job_id = ao.job_id /*modified for bug 9257637 */
2031: -- AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 *//*commented for bug 9257637 */
2032: AND p_task_id = ao.task_id
2033: AND l_called_process <>1 /*Added for Doosan rate api change */
2034: AND p_item_date
2035: BETWEEN ao.start_date_active

Line 2078: -- AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 //commented for bug 9257637 */

2074: FROM pa_bill_rates_all b, pa_job_assignment_overrides ao, pa_tasks t
2075: WHERE ao.person_id = p_person_id
2076: AND b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2077: AND b.job_id = ao.job_id
2078: -- AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id) /* Bug 6058676 *//*commented for bug 9257637 */
2079: AND t.project_id = ao.project_id
2080: AND t.task_id = p_task_id
2081: AND l_called_process <>2 /*Added for Doosan rate api change */
2082: AND p_item_date

Line 2176: AND b.job_id = pa_cross_business_grp.IsmappedTojob(nvl(p_resource_job_id,pa.job_id),l_bill_job_grp_id)

2172: AND pa.assignment_type IN ('E','C') -- Modified for CWK changes
2173: AND p_item_date /* BUG#3118592 */
2174: BETWEEN pa.effective_start_date
2175: AND pa.effective_end_date
2176: AND b.job_id = pa_cross_business_grp.IsmappedTojob(nvl(p_resource_job_id,pa.job_id),l_bill_job_grp_id)
2177: /* Changed the join instead of joining with p_resource_job_id, now joining using function IsmappedTojob to fix bug 2155331 */ /* Bug 6058676 */
2178: AND NVL(l_labor_schdl_fixed_date,p_item_date)/*modified above line condition for bug 9257637 */
2179: BETWEEN b.start_date_active
2180: AND NVL(b.end_date_active,

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

2265: l_rate_currency_code
2266: l_markup_percentage
2267: FROM pa_bill_rates_all b
2268: WHERE b.bill_rate_sch_id = l_job_bill_rate_schedule_id
2269: AND b.job_id = pa_cross_business_grp.IsmappedTojob(p_resource_job_id,l_bill_job_grp_id)
2270: AND NVL(l_labor_schdl_fixed_date,p_item_date)
2271: BETWEEN b.start_date_active
2272: AND NVL(b.end_date_active,
2273: NVL(l_labor_schdl_fixed_date,p_item_date))