APPS.PAY_GBATGN dependencies on FF_ROUTES_S

Line 39: select ff_routes_s.currval,

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

Line 56: ff_routes_s.currval,

52: parameter_name,
53: data_type)
54: values
55: (ff_route_parameters_s.nextval,
56: ff_routes_s.currval,
57: 1,
58: 'Balance Type ID',
59: 'N');
60: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',40);

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

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

Line 76: (ff_routes_s.nextval,

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

Line 158: (ff_routes_s.nextval,

154: route_name,
155: description,
156: text)
157: values
158: (ff_routes_s.nextval,
159: 'N',
160: 'GB Assignment-level Tax Year to Date Balance Dimension',
161: 'Summed data for the ASSIGNMENT-LEVEL GB TAX YEAR TO DATE balance dimension',
162: ' pay_balance_feeds_f FEED

Line 232: (ff_routes_s.nextval,

228: route_name,
229: description,
230: text)
231: values
232: (ff_routes_s.nextval,
233: 'N',
234: 'GB Person-level Period to Date Balance Dimension',
235: 'Summed data for the PERSON-LEVEL PERIOD TO DATE balance dimension',
236: ' pay_balance_feeds_f FEED

Line 312: (ff_routes_s.nextval,

308: route_name,
309: description,
310: text)
311: values
312: (ff_routes_s.nextval,
313: 'N',
314: 'GB Assignment-level Period to Date Balance Dimension',
315: 'Summed data for the ASSIGNMENT-LEVEL PERIOD TO DATE balance dimension',
316: ' pay_balance_feeds_f FEED

Line 384: (ff_routes_s.nextval,

380: route_name,
381: description,
382: text)
383: values
384: (ff_routes_s.nextval,
385: 'N',
386: 'GB Person-level User Cleared Balance Dimension',
387: 'Summed data for the PERSON-LEVEL USER CLEARED balance dimension',
388: ' pay_balance_feeds_f FEED

Line 442: (ff_routes_s.nextval,

438: route_name,
439: description,
440: text)
441: values
442: (ff_routes_s.nextval,
443: 'N',
444: 'GB Assignment-level User Cleared Balance Dimension',
445: 'Summed data for the ASSIGNMENT-LEVEL USER CLEARED balance dimension',
446: ' pay_balance_feeds_f FEED

Line 492: (ff_routes_s.nextval,

488: route_name,
489: description,
490: text)
491: values
492: (ff_routes_s.nextval,
493: 'N',
494: 'GB Assignment-level Current Run Balance Dimension',
495: 'Summed data for the ASSIGNMENT-LEVEL CURRENT RUN balance dimension',
496: ' pay_balance_feeds_f FEED

Line 538: (ff_routes_s.nextval,

534: route_name,
535: description,
536: text)
537: values
538: (ff_routes_s.nextval,
539: 'N',
540: 'GB Person-level Contracted In YTD Balance Dimension',
541: 'Summed data for the PERSON-LEVEL CONTRACTED IN YTD balance dimension',
542: ' pay_balance_feeds_f FEED

Line 628: (ff_routes_s.nextval,

624: route_name,
625: description,
626: text)
627: values
628: (ff_routes_s.nextval,
629: 'N',
630: 'GB Payments Balance Dimension',
631: 'Summed data for the PAYMENTS balance dimension',
632: ' pay_balance_feeds_f FEED