APPS.PSP_PSPENASG_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 33: FROM hr_all_organization_units

29:
30: function cf_org_nameformula(reference_id in number, assignment_id in number, action_type in varchar2, change_type in varchar2) return char is
31: CURSOR c_org IS
32: SELECT name
33: FROM hr_all_organization_units
34: WHERE organization_id = reference_id;
35:
36: CURSOR c_org_acct IS
37: SELECT hrou.name

Line 38: FROM hr_all_organization_units hrou,

34: WHERE organization_id = reference_id;
35:
36: CURSOR c_org_acct IS
37: SELECT hrou.name
38: FROM hr_all_organization_units hrou,
39: Psp_organization_accounts poa
40: WHERE poa.organization_id = hrou.organization_id
41: AND poa.organization_account_id = reference_id;
42:

Line 45: FROM hr_all_organization_units hrou,

41: AND poa.organization_account_id = reference_id;
42:
43: CURSOR c_org_enc_date IS
44: SELECT hrou.name
45: FROM hr_all_organization_units hrou,
46: Psp_enc_end_dates peed
47: WHERE peed.organization_id = hrou.organization_id
48: AND peed.enc_end_date_id = reference_id;
49:

Line 53: FROM hr_all_organization_units hou,

49:
50:
51: CURSOR c_org_acct_del IS
52: SELECT hou.name
53: FROM hr_all_organization_units hou,
54: per_all_assignments_f paf
55: WHERE paf.assignment_id =assignment_id
56: AND paf.organization_id= hou.organization_id
57: AND sysdate between paf.effective_start_date and paf.effective_end_date;

Line 63: FROM hr_all_organization_units hrou,

59:
60:
61: CURSOR c_org_def_sch IS
62: SELECT hrou.name
63: FROM hr_all_organization_units hrou,
64: psp_default_labor_schedules pdls
65: WHERE pdls.organization_id = hrou.organization_id
66: AND pdls.org_schedule_id = reference_id;
67:

Line 78: v_orgName hr_all_organization_units.name%TYPE;

74: AND pecsh.request_id = p_request_id
75: AND pecsh.change_type = 'GS'
76: AND pecsh.action_type ='G' ;
77:
78: v_orgName hr_all_organization_units.name%TYPE;
79:
80: BEGIN
81:
82: IF action_type = 'I'