APPS.PAY_GBATGN dependencies on FF_ROUTE_PARAMETERS

Line 45: -- insert row into ff_route_parameters

41: 1
42: from ff_contexts CON
43: where CON.context_name = 'ASSIGNMENT_ACTION_ID';
44: --
45: -- insert row into ff_route_parameters
46: --
47: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',30);
48: insert into ff_route_parameters
49: (route_parameter_id,

Line 48: insert into ff_route_parameters

44: --
45: -- insert row into ff_route_parameters
46: --
47: hr_utility.set_location('pay_gbatgn.insert_gb_dimensions',30);
48: insert into ff_route_parameters
49: (route_parameter_id,
50: route_id,
51: sequence_no,
52: parameter_name,

Line 55: (ff_route_parameters_s.nextval,

51: sequence_no,
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');

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: --