APPS.PAY_BALANCE_FEED_DEL_PKG dependencies on PAY_DEFINED_BALANCES

Line 175: from pay_defined_balances pdb,

171: cursor plbc is
172: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
173: USE_NL (PLB) */
174: plb.latest_balance_id
175: from pay_defined_balances pdb,
176: pay_person_latest_balances plb
177: where pdb.balance_type_id = l_balance_type_id
178: and plb.defined_balance_id = pdb.defined_balance_id
179: and exists (

Line 191: from pay_defined_balances pdb,

187: --
188: cursor lbc is
189: select
190: lb.latest_balance_id
191: from pay_defined_balances pdb,
192: pay_latest_balances lb
193: where pdb.balance_type_id = l_balance_type_id
194: and lb.defined_balance_id = pdb.defined_balance_id
195: and exists (

Line 210: from pay_defined_balances pdb,

206: cursor platbalc is
207: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
208: USE_NL (PLB) */
209: plb.latest_balance_id
210: from pay_defined_balances pdb,
211: pay_person_latest_balances plb
212: where pdb.balance_type_id = l_balance_type_id
213: and plb.defined_balance_id = pdb.defined_balance_id;
214: --

Line 222: from pay_defined_balances pdb,

218: cursor latbalc is
219: select /*+ ORDERED INDEX (PLB PAY_LATEST_BALANCES_FK1)
220: USE_NL (PLB) */
221: plb.latest_balance_id
222: from pay_defined_balances pdb,
223: pay_latest_balances plb
224: where pdb.balance_type_id = l_balance_type_id
225: and plb.defined_balance_id = pdb.defined_balance_id;
226: --

Line 244: pay_defined_balances pdb,

240: cursor pl_feed_chk is
241: select plb.latest_balance_id,
242: 'P' balance_type
243: from pay_person_latest_balances plb,
244: pay_defined_balances pdb,
245: pay_balance_dimensions pbd
246: where pdb.balance_type_id = l_balance_type_id
247: and pdb.defined_balance_id = plb.defined_balance_id
248: and pdb.balance_dimension_id = pbd.balance_dimension_id

Line 254: pay_defined_balances pdb,

250: union
251: select plb.latest_balance_id,
252: 'B' balance_type
253: from pay_latest_balances plb,
254: pay_defined_balances pdb,
255: pay_balance_dimensions pbd
256: where pdb.balance_type_id = l_balance_type_id
257: and pdb.defined_balance_id = plb.defined_balance_id
258: and pdb.balance_dimension_id = pbd.balance_dimension_id

Line 937: from pay_defined_balances pdb,

933: p_input_value_id in varchar2) is
934: select /*+ ORDERED INDEX (PLB PAY_ASSIGNMENT_LATEST_BALA_FK2)
935: USE_NL (PLB) */
936: plb.latest_balance_id
937: from pay_defined_balances pdb,
938: pay_assignment_latest_balances plb
939: where pdb.balance_type_id = p_balance_type_id
940: and plb.defined_balance_id = pdb.defined_balance_id
941: and plb.assignment_id between p_assnmnt_start_id and p_assnmnt_end_id

Line 958: from pay_defined_balances pdb,

954: p_balance_type_id in varchar2) is
955: select /*+ ORDERED INDEX (PLB PAY_ASSIGNMENT_LATEST_BALA_FK2)
956: USE_NL (PLB) */
957: plb.latest_balance_id
958: from pay_defined_balances pdb,
959: pay_assignment_latest_balances plb
960: where pdb.balance_type_id = p_balance_type_id
961: and plb.defined_balance_id = pdb.defined_balance_id
962: and plb.assignment_id between p_assnmnt_start_id and p_assnmnt_end_id;

Line 970: pay_defined_balances pdb,

966: p_assnmnt_end_id in varchar2,
967: p_balance_type_id in varchar2) is
968: select alb.latest_balance_id
969: from pay_assignment_latest_balances alb,
970: pay_defined_balances pdb,
971: pay_balance_dimensions pbd
972: where pdb.balance_type_id = p_balance_type_id
973: and pdb.defined_balance_id = alb.defined_balance_id
974: and pdb.balance_dimension_id = pbd.balance_dimension_id