APPS.PSP_PSPENASG_XMLP_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 140: FROM pay_element_types_f petf

136: function cf_element_nameformula(reference_id in number, action_type in varchar2, change_type in varchar2) return char is
137:
138: CURSOR c_element IS
139: SELECT element_name
140: FROM pay_element_types_f petf
141: WHERE element_type_id = reference_id
142: AND ( trunc(sysdate) BETWEEN effective_start_date AND effective_end_date
143: OR ( trunc(sysdate) < (select min(effective_start_date ) from pay_element_types_f petf1
144: where petf1.element_type_id= petf.element_type_id)));

Line 143: OR ( trunc(sysdate) < (select min(effective_start_date ) from pay_element_types_f petf1

139: SELECT element_name
140: FROM pay_element_types_f petf
141: WHERE element_type_id = reference_id
142: AND ( trunc(sysdate) BETWEEN effective_start_date AND effective_end_date
143: OR ( trunc(sysdate) < (select min(effective_start_date ) from pay_element_types_f petf1
144: where petf1.element_type_id= petf.element_type_id)));
145:
146: CURSOR c_element_acct IS
147: SELECT pet.element_name

Line 148: FROM pay_element_types_f pet,

144: where petf1.element_type_id= petf.element_type_id)));
145:
146: CURSOR c_element_acct IS
147: SELECT pet.element_name
148: FROM pay_element_types_f pet,
149: Psp_element_type_accounts peta
150: WHERE pet.element_type_id = peta.element_type_id
151: AND Peta.element_account_id = reference_id
152: AND ( trunc(sysdate) BETWEEN pet.effective_start_date AND

Line 154: OR ( trunc(sysdate) < (select min(effective_start_date ) from pay_element_types_f petf1

150: WHERE pet.element_type_id = peta.element_type_id
151: AND Peta.element_account_id = reference_id
152: AND ( trunc(sysdate) BETWEEN pet.effective_start_date AND
153: pet.effective_end_date
154: OR ( trunc(sysdate) < (select min(effective_start_date ) from pay_element_types_f petf1
155: where petf1.element_type_id= pet.element_type_id)));
156:
157:
158: CURSOR c_element_acct_del IS

Line 160: FROM pay_element_types_f pet,

156:
157:
158: CURSOR c_element_acct_del IS
159: SELECT pet.element_name
160: FROM pay_element_types_f pet,
161: psp_enc_lines_history pelh
162: WHERE
163: pelh.element_account_id= reference_id
164: AND pelh.enc_element_type_id= pet.element_type_id

Line 167: v_elementName pay_element_types_f.element_name%TYPE;

163: pelh.element_account_id= reference_id
164: AND pelh.enc_element_type_id= pet.element_type_id
165: AND rownum=1 ;
166:
167: v_elementName pay_element_types_f.element_name%TYPE;
168:
169:
170: BEGIN
171: