APPS.PAY_GBATGN dependencies on DUAL

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

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

Line 140: from dual;

136: + decode(sign( l_user_effective_date - to_date(''06-04-''
137: || to_char(l_user_effective_date,''YYYY''),''DD-MM-YYYY'')),
138: -1,-1,0)),''DD-MM-YYYY'')
139: into l_tax_year_start
140: from dual;
141: -- see if balance was written in this tax year. If not, it''s expired.
142: if l_owner_effective_date >= l_tax_year_start then
143: l_dimension_expired := 0;
144: else

Line 185: from dual)

181: to_char( BACT.effective_date,''YYYY''))
182: + decode(sign( BACT.effective_date - to_date(''06-04-''
183: || to_char(BACT.effective_date,''YYYY''),''DD-MM-YYYY'')),
184: -1,-1,0)),''DD-MM-YYYY'')
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

Line 214: from dual;

210: + decode(sign( l_user_effective_date - to_date(''06-04-''
211: || to_char(l_user_effective_date,''YYYY''),''DD-MM-YYYY'')),
212: -1,-1,0)),''DD-MM-YYYY'')
213: into l_tax_year_start
214: from dual;
215: -- see if balance was written in this tax year. If not, it''s expired.
216: if l_owner_effective_date >= l_tax_year_start then
217: l_dimension_expired := 0;
218: else

Line 610: from dual;

606: + decode(sign( l_user_effective_date - to_date(''06-04-''
607: || to_char(l_user_effective_date,''YYYY''),''DD-MM-YYYY'')),
608: -1,-1,0)),''DD-MM-YYYY'')
609: into l_tax_year_start
610: from dual;
611: -- see if balance was written in this tax year. If not, it''s expired.
612: if l_owner_effective_date >= l_tax_year_start then
613: l_dimension_expired := 0;
614: else