APPS.BEN_CWB_XCHG_PKG dependencies on BEN_CWB_PERSON_INFO

Line 45: from ben_cwb_person_info

41: --
42: -- cursor to fetch the records from person_info and rates where personId is -1
43: cursor csr_xchg_recs_bm(p_group_pl_id number, p_lf_evt_ocrd_dt date) is
44: select distinct base_salary_currency lCurrency
45: from ben_cwb_person_info
46: where group_pl_id = p_group_pl_id
47: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
48: and person_id = -1
49: and base_salary_currency is not null

Line 53: from ben_cwb_person_info

49: and base_salary_currency is not null
50:
51: UNION
52: select distinct salary_1_year_ago_currency lCurrency
53: from ben_cwb_person_info
54: where group_pl_id = p_group_pl_id
55: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
56: and person_id = -1
57: and salary_1_year_ago_currency is not null

Line 61: from ben_cwb_person_info

57: and salary_1_year_ago_currency is not null
58:
59: UNION
60: select distinct salary_2_year_ago_currency lCurrency
61: from ben_cwb_person_info
62: where group_pl_id = p_group_pl_id
63: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
64: and person_id = -1
65: and salary_2_year_ago_currency is not null

Line 69: from ben_cwb_person_info

65: and salary_2_year_ago_currency is not null
66:
67: UNION
68: select distinct salary_3_year_ago_currency lCurrency
69: from ben_cwb_person_info
70: where group_pl_id = p_group_pl_id
71: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
72: and person_id = -1
73: and salary_3_year_ago_currency is not null

Line 77: from ben_cwb_person_info

73: and salary_3_year_ago_currency is not null
74:
75: UNION
76: select distinct salary_4_year_ago_currency lCurrency
77: from ben_cwb_person_info
78: where group_pl_id = p_group_pl_id
79: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
80: and person_id = -1
81: and salary_4_year_ago_currency is not null

Line 85: from ben_cwb_person_info

81: and salary_4_year_ago_currency is not null
82:
83: UNION
84: select distinct salary_5_year_ago_currency lCurrency
85: from ben_cwb_person_info
86: where group_pl_id = p_group_pl_id
87: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
88: and person_id = -1
89: and salary_5_year_ago_currency is not null

Line 93: from ben_cwb_person_info

89: and salary_5_year_ago_currency is not null
90:
91: UNION
92: select distinct mkt_currency lCurrency
93: from ben_cwb_person_info
94: where group_pl_id = p_group_pl_id
95: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
96: and person_id = -1
97: and mkt_currency is not null

Line 101: from ben_cwb_person_info

97: and mkt_currency is not null
98:
99: UNION
100: select distinct prev_sal_currency lCurrency
101: from ben_cwb_person_info
102: where group_pl_id = p_group_pl_id
103: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
104: and person_id = -1
105: and prev_sal_currency is not null

Line 111: ,ben_cwb_person_info cpi

107: UNION
108:
109: select distinct cpr.currency lCurrency
110: from ben_cwb_person_rates cpr
111: ,ben_cwb_person_info cpi
112: where cpr.group_per_in_ler_id = cpi.group_per_in_ler_id
113: and cpi.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
114: and cpi.group_pl_id = p_group_pl_id
115: and cpi.person_id = -1

Line 123: from ben_cwb_person_info

119: -- cursor to fetch the records from person_info and rates
120: -- for refresh
121: cursor csr_xchg_recs_rf(p_group_pl_id number, p_lf_evt_ocrd_dt date) is
122: select distinct base_salary_currency lCurrency
123: from ben_cwb_person_info
124: where group_pl_id = p_group_pl_id
125: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
126: and base_salary_currency is not null
127:

Line 138: from ben_cwb_person_info

134: and cpr.currency is not null
135:
136: UNION
137: select distinct salary_1_year_ago_currency lCurrency
138: from ben_cwb_person_info
139: where group_pl_id = p_group_pl_id
140: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
141: and salary_1_year_ago_currency is not null
142:

Line 145: from ben_cwb_person_info

141: and salary_1_year_ago_currency is not null
142:
143: UNION
144: select distinct salary_2_year_ago_currency lCurrency
145: from ben_cwb_person_info
146: where group_pl_id = p_group_pl_id
147: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
148: and salary_2_year_ago_currency is not null
149:

Line 152: from ben_cwb_person_info

148: and salary_2_year_ago_currency is not null
149:
150: UNION
151: select distinct salary_3_year_ago_currency lCurrency
152: from ben_cwb_person_info
153: where group_pl_id = p_group_pl_id
154: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
155: and salary_3_year_ago_currency is not null
156:

Line 159: from ben_cwb_person_info

155: and salary_3_year_ago_currency is not null
156:
157: UNION
158: select distinct salary_4_year_ago_currency lCurrency
159: from ben_cwb_person_info
160: where group_pl_id = p_group_pl_id
161: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
162: and salary_4_year_ago_currency is not null
163:

Line 166: from ben_cwb_person_info

162: and salary_4_year_ago_currency is not null
163:
164: UNION
165: select distinct salary_5_year_ago_currency lCurrency
166: from ben_cwb_person_info
167: where group_pl_id = p_group_pl_id
168: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
169: and salary_5_year_ago_currency is not null
170:

Line 173: from ben_cwb_person_info

169: and salary_5_year_ago_currency is not null
170:
171: UNION
172: select distinct mkt_currency lCurrency
173: from ben_cwb_person_info
174: where group_pl_id = p_group_pl_id
175: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
176: and mkt_currency is not null
177:

Line 180: from ben_cwb_person_info

176: and mkt_currency is not null
177:
178: UNION
179: select distinct prev_sal_currency lCurrency
180: from ben_cwb_person_info
181: where group_pl_id = p_group_pl_id
182: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
183: and prev_sal_currency is not null;
184: