APPS.PAY_AUTOGN dependencies on DUAL

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 107: from dual)

103: to_char( BACT.effective_date,''YYYY''))
104: + decode(sign( BACT.effective_date - to_date(''06-04-''
105: || to_char(BACT.effective_date,''YYYY''),''DD-MM-YYYY'')),
106: -1,-1,0)),''DD-MM-YYYY'')
107: from dual)
108: and ASSACT.action_sequence <= BAL_ASSACT.action_sequence
109: and START_ASS.assignment_id = BAL_ASSACT.assignment_id
110: and ASS.period_of_service_id = START_ASS.period_of_service_id
111: and ASSACT.assignment_id = ASS.assignment_id

Line 171: from dual)

167: to_char( BACT.effective_date,''YYYY''))
168: + decode(sign( BACT.effective_date - to_date(''06-04-''
169: || to_char(BACT.effective_date,''YYYY''),''DD-MM-YYYY'')),
170: -1,-1,0)),''DD-MM-YYYY'')
171: from dual)
172: and ASSACT.action_sequence <= BAL_ASSACT.action_sequence
173: and ASSACT.assignment_id = BAL_ASSACT.assignment_id');
174: --
175: -- now insert rows into ff_route_context_usages and ff_route_parameters