APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PSB_DATA_EXTRACT_ORGS

Line 235: from psb_data_extract_orgs

231: AND ( p_extract_by_org = 'N'
232: OR
233: (p_extract_by_org = 'Y' and pp.organization_id in
234: (select organization_id
235: from psb_data_extract_orgs
236: where data_extract_id = p_data_extract_id
237: and select_flag = 'Y' )
238: )
239: )

Line 328: from psb_data_extract_orgs

324: AND ( p_extract_by_org = 'N'
325: OR
326: (p_extract_by_org = 'Y' and pp.organization_id in
327: ( select organization_id
328: from psb_data_extract_orgs
329: where data_extract_id = p_data_extract_id
330: and select_flag = 'Y'
331: )
332: )

Line 1734: from psb_data_extract_orgs

1730:
1731: AND (p_extract_by_org = 'N' OR
1732: (p_extract_by_org = 'Y' and pp.organization_id in
1733: (select organization_id
1734: from psb_data_extract_orgs
1735: where data_extract_id = p_data_extract_id
1736: and select_flag = 'Y')))
1737: ORDER BY paf.assignment_id;
1738:

Line 2294: from psb_data_extract_orgs

2290: AND (p_extract_by_org = l_no
2291: OR
2292: (p_extract_by_org = l_yes and paf.organization_id in
2293: (select organization_id
2294: from psb_data_extract_orgs
2295: where data_extract_id = p_data_extract_id
2296: and select_flag = l_yes)))
2297:
2298: */

Line 2325: from psb_data_extract_orgs

2321: = pcak.cost_allocation_keyflex_id
2322: AND (p_extract_by_org = l_no OR
2323: (p_extract_by_org = l_yes and paf.organization_id in
2324: (select organization_id
2325: from psb_data_extract_orgs
2326: where data_extract_id = p_data_extract_id
2327: and select_flag = l_yes)))
2328:
2329: union all

Line 2354: from psb_data_extract_orgs

2350: and fs.effective_date between pcax.effective_start_date and pcax.effective_end_date)
2351: AND (p_extract_by_org = l_no OR
2352: (p_extract_by_org = l_yes and paf.organization_id in
2353: (select organization_id
2354: from psb_data_extract_orgs
2355: where data_extract_id = p_data_extract_id
2356: and select_flag = l_yes)))
2357:
2358: order by 1,2;

Line 4443: from psb_data_extract_orgs

4439:
4440: and (p_extract_by_org = 'N' OR
4441: (p_extract_by_org = 'Y' and a.organization_id in
4442: (select organization_id
4443: from psb_data_extract_orgs
4444: where data_extract_id = p_data_extract_id
4445: and select_flag = 'Y')))
4446:
4447: UNION ALL

Line 4479: from psb_data_extract_orgs

4475:
4476: and (p_extract_by_org = 'N' OR
4477: (p_extract_by_org = 'Y' and a.organization_id in
4478: (select organization_id
4479: from psb_data_extract_orgs
4480: where data_extract_id = p_data_extract_id
4481: and select_flag = 'Y')));
4482:
4483: /*For Bug No : 2642012 End*/