APPS.PAY_AUTOGN dependencies on FF_ROUTES_S

Line 41: select ff_routes_s.currval,

37: insert into ff_route_context_usages
38: (route_id,
39: context_id,
40: sequence_no)
41: select ff_routes_s.currval,
42: CON.context_id,
43: 1
44: from ff_contexts CON
45: where CON.context_name = 'ASSIGNMENT_ACTION_ID';

Line 58: ff_routes_s.currval,

54: parameter_name,
55: data_type)
56: values
57: (ff_route_parameters_s.nextval,
58: ff_routes_s.currval,
59: 1,
60: 'Balance Type ID',
61: 'N');
62: hr_utility.set_location('pay_autogn.insert_bf_dimensions',40);

Line 63: select ff_routes_s.currval into x from dual;

59: 1,
60: 'Balance Type ID',
61: 'N');
62: hr_utility.set_location('pay_autogn.insert_bf_dimensions',40);
63: select ff_routes_s.currval into x from dual;
64: --
65: return x;
66: --
67: end do_child_inserts;

Line 78: (ff_routes_s.nextval,

74: route_name,
75: description,
76: text)
77: values
78: (ff_routes_s.nextval,
79: 'N',
80: 'BF Person-level Tax Year to Date Balance Dimension',
81: 'Summed data for the PERSON-LEVEL BF TAX YEAR TO DATE balance dimension',
82: ' pay_balance_feeds_f FEED

Line 144: (ff_routes_s.nextval,

140: route_name,
141: description,
142: text)
143: values
144: (ff_routes_s.nextval,
145: 'N',
146: 'BF Assignment-level Tax Year to Date Balance Dimension',
147: 'Summed data for the ASSIGNMENT-LEVEL BF TAX YEAR TO DATE balance dimension',
148: ' pay_balance_feeds_f FEED

Line 202: (ff_routes_s.nextval,

198: route_name,
199: description,
200: text)
201: values
202: (ff_routes_s.nextval,
203: 'N',
204: 'BF Person-level Period to Date Balance Dimension',
205: 'Summed data for the PERSON-LEVEL PERIOD TO DATE balance dimension',
206: ' pay_balance_feeds_f FEED

Line 267: (ff_routes_s.nextval,

263: route_name,
264: description,
265: text)
266: values
267: (ff_routes_s.nextval,
268: 'N',
269: 'BF Assignment-level Period to Date Balance Dimension',
270: 'Summed data for the ASSIGNMENT-LEVEL PERIOD TO DATE balance dimension',
271: ' pay_balance_feeds_f FEED

Line 324: (ff_routes_s.nextval,

320: route_name,
321: description,
322: text)
323: values
324: (ff_routes_s.nextval,
325: 'N',
326: 'BF Person-level Period to Date Balance Dimension (test)',
327: 'Summed data for the PERSON-LEVEL PERIOD TO DATE balance dimension (test)',
328: ' pay_balance_feeds_f FEED

Line 389: (ff_routes_s.nextval,

385: route_name,
386: description,
387: text)
388: values
389: (ff_routes_s.nextval,
390: 'N',
391: 'BF Person-level User Cleared Balance Dimension',
392: 'Summed data for the PERSON-LEVEL USER CLEARED balance dimension',
393: ' pay_balance_feeds_f FEED

Line 448: (ff_routes_s.nextval,

444: route_name,
445: description,
446: text)
447: values
448: (ff_routes_s.nextval,
449: 'N',
450: 'BF Assignment-level User Cleared Balance Dimension',
451: 'Summed data for the ASSIGNMENT-LEVEL USER CLEARED balance dimension',
452: ' pay_balance_feeds_f FEED

Line 499: (ff_routes_s.nextval,

495: route_name,
496: description,
497: text)
498: values
499: (ff_routes_s.nextval,
500: 'N',
501: 'BF Assignment-level User Cleared Balance Dimension (not fed)',
502: 'Summed data for the ASSIGNMENT-LEVEL USER balance dimension (not fed)',
503: ' pay_balance_feeds_f FEED

Line 550: (ff_routes_s.nextval,

546: route_name,
547: description,
548: text)
549: values
550: (ff_routes_s.nextval,
551: 'N',
552: 'BF Assignment-level Current Run Balance Dimension',
553: 'Summed data for the ASSIGNMENT-LEVEL CURRENT RUN balance dimension',
554: ' pay_balance_feeds_f FEED

Line 596: (ff_routes_s.nextval,

592: route_name,
593: description,
594: text)
595: values
596: (ff_routes_s.nextval,
597: 'N',
598: 'BF Person-level Contracted In YTD Balance Dimension',
599: 'Summed data for the PERSON-LEVEL CONTRACTED IN YTD balance dimension',
600: ' pay_balance_feeds_f FEED

Line 655: (ff_routes_s.nextval,

651: route_name,
652: description,
653: text)
654: values
655: (ff_routes_s.nextval,
656: 'N',
657: 'BF Payments Balance Dimension',
658: 'Summed data for the PAYMENTS balance dimension',
659: ' pay_balance_feeds_f FEED