APPS.PA_CC_TP_UTILS dependencies on DUAL

Line 15: from dual

11: IS
12:
13: CURSOR c_tp_rule IS
14: select '1'
15: from dual
16: where exists (select 'Y'
17: from pa_cc_tp_schedule_lines sl
18: where sl.labor_tp_rule_id=p_rule_id
19: or sl.nl_tp_rule_id=p_rule_id);

Line 53: select '1' from dual

49: function get_lowest_org_level(p_organization_id in number) return varchar2
50: is
51:
52: cursor c_ou is
53: select '1' from dual
54: where exists (select 'Y'
55: from hr_operating_units o
56: where o.business_group_id=decode(G_global_access,'Y',business_group_id,G_business_group_id)
57: and o.organization_id=p_organization_id);

Line 59: select '1' from dual

55: from hr_operating_units o
56: where o.business_group_id=decode(G_global_access,'Y',business_group_id,G_business_group_id)
57: and o.organization_id=p_organization_id);
58: cursor c_le is
59: select '1' from dual
60: where exists (select 'Y'
61: from hr_legal_entities o
62: where o.business_group_id=decode(G_global_access,'Y',business_group_id,G_business_group_id)
63: and o.organization_id=p_organization_id);

Line 66: select '1' from dual

62: where o.business_group_id=decode(G_global_access,'Y',business_group_id,G_business_group_id)
63: and o.organization_id=p_organization_id);
64:
65: cursor c_bg is
66: select '1' from dual
67: where exists (select 'Y'
68: from hr_organization_units o1,
69: hr_organization_information o2
70: where o1.organization_id=o2.organization_id

Line 417: select '1' from dual

413: function get_highest_org_level(p_organization_id in number)
414: return varchar2
415: IS
416: cursor c_bg is
417: select '1' from dual
418: where exists (select 'Y'
419: from hr_organization_units o1,
420: hr_organization_information o2
421: where o1.organization_id=o2.organization_id

Line 427: select '1' from dual

423: and o2.org_information_context||''='CLASS'
424: and o2.org_information1='HR_BG');
425:
426: cursor c_ou is
427: select '1' from dual
428: where exists (select 'Y'
429: from hr_operating_units
430: where organization_id=p_organization_id
431: and business_group_id=decode(G_global_access,'Y',business_group_id,G_business_group_id));

Line 433: select '1' from dual

429: from hr_operating_units
430: where organization_id=p_organization_id
431: and business_group_id=decode(G_global_access,'Y',business_group_id,G_business_group_id));
432: cursor c_le is
433: select '1' from dual
434: where exists (select 'Y'
435: from hr_legal_entities
436: where organization_id=p_organization_id
437: and business_group_id=decode(G_global_access,'Y',business_group_id,G_business_group_id));