APPS.PAY_GBATGN dependencies on FF_ROUTE_CONTEXT_USAGES

Line 32: -- insert row into ff_route_context_usages

28: function do_child_inserts return number is
29: x number;
30: begin
31: --
32: -- insert row into ff_route_context_usages
33: --
34: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',20);
35: insert into ff_route_context_usages
36: (route_id,

Line 35: insert into ff_route_context_usages

31: --
32: -- insert row into ff_route_context_usages
33: --
34: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',20);
35: insert into ff_route_context_usages
36: (route_id,
37: context_id,
38: sequence_no)
39: select ff_routes_s.currval,

Line 115: -- now insert rows into ff_route_context_usages and ff_route_parameters

111: ASS.effective_start_date and ASS.effective_end_date
112: and PACT.effective_date between
113: START_ASS.effective_start_date and START_ASS.effective_end_date');
114: --
115: -- now insert rows into ff_route_context_usages and ff_route_parameters
116: -- and load variable with the current route_id
117: --
118: x := do_child_inserts;
119: --

Line 189: -- now insert rows into ff_route_context_usages and ff_route_parameters

185: from dual)
186: and ASSACT.action_sequence <= BAL_ASSACT.action_sequence
187: and ASSACT.assignment_id = BAL_ASSACT.assignment_id');
188: --
189: -- now insert rows into ff_route_context_usages and ff_route_parameters
190: -- and load variable with the current route_id
191: --
192: x := do_child_inserts;
193: --

Line 269: -- now insert rows into ff_route_context_usages and ff_route_parameters

265: ASS.effective_start_date and ASS.effective_end_date
266: and PACT.effective_date between
267: START_ASS.effective_start_date and START_ASS.effective_end_date');
268: --
269: -- now insert rows into ff_route_context_usages and ff_route_parameters
270: -- and load variable with the current route_id
271: --
272: x := do_child_inserts;
273: --

Line 341: -- now insert rows into ff_route_context_usages and ff_route_parameters

337: )
338: and ASSACT.action_sequence <= BAL_ASSACT.action_sequence
339: and ASSACT.assignment_id = BAL_ASSACT.assignment_id');
340: --
341: -- now insert rows into ff_route_context_usages and ff_route_parameters
342: -- and load variable with the current route_id
343: --
344: x := do_child_inserts;
345: --

Line 416: -- now insert rows into ff_route_context_usages and ff_route_parameters

412: ASS.effective_start_date and ASS.effective_end_date
413: and PACT.effective_date between
414: START_ASS.effective_start_date and START_ASS.effective_end_date');
415: --
416: -- now insert rows into ff_route_context_usages and ff_route_parameters
417: -- and load variable with the current route_id
418: --
419: x := do_child_inserts;
420: --

Line 466: -- now insert rows into ff_route_context_usages and ff_route_parameters

462: and RR.status in (''P'',''PA'')
463: and ASSACT.action_sequence <= BAL_ASSACT.action_sequence
464: and ASSACT.assignment_id = BAL_ASSACT.assignment_id');
465: --
466: -- now insert rows into ff_route_context_usages and ff_route_parameters
467: -- and load variable with the current route_id
468: --
469: x := do_child_inserts;
470: --

Line 512: -- now insert rows into ff_route_context_usages and ff_route_parameters

508: FEED.effective_start_date and FEED.effective_end_date
509: and RR.status in (''P'',''PA'')
510: and ASSACT.assignment_id = BAL_ASSACT.assignment_id');
511: --
512: -- now insert rows into ff_route_context_usages and ff_route_parameters
513: -- and load variable with the current route_id
514: --
515: x := do_child_inserts;
516: --

Line 570: -- now insert rows into ff_route_context_usages and ff_route_parameters

566: ASS.effective_start_date and ASS.effective_end_date
567: and PACT.effective_date between
568: START_ASS.effective_start_date and START_ASS.effective_end_date');
569: --
570: -- now insert rows into ff_route_context_usages and ff_route_parameters
571: -- and load variable with the current route_id
572: --
573: x := do_child_inserts;
574: --

Line 655: -- now insert rows into ff_route_context_usages and ff_route_parameters

651: and INTLK.locking_action_id = BAL_ASSACT.assignment_action_id
652: and BACT.action_type = ''P''
653: and ASSACT.assignment_id = BAL_ASSACT.assignment_id');
654: --
655: -- now insert rows into ff_route_context_usages and ff_route_parameters
656: -- and load variable with the current route_id
657: --
658: x := do_child_inserts;
659: --