APPS.PAY_CA_RL2_MAG dependencies on PAY_CA_RL2_REG

Line 259: decode(pay_ca_rl2_reg.get_parameter('P_S1',ppa1.legislative_parameters),

255: where paaf2.assignment_id = paf.assignment_id
256: and paaf2.effective_start_date <= ppa1.effective_date
257: )
258: order by
259: decode(pay_ca_rl2_reg.get_parameter('P_S1',ppa1.legislative_parameters),
260: 'RL1_PRE',hou.name,
261: 'RL1_ORG',hou1.name,
262: 'RL1_LOC',loc.location_code,null)
263: ,decode(pay_ca_rl2_reg.get_parameter('P_S2',ppa1.legislative_parameters),

Line 263: ,decode(pay_ca_rl2_reg.get_parameter('P_S2',ppa1.legislative_parameters),

259: decode(pay_ca_rl2_reg.get_parameter('P_S1',ppa1.legislative_parameters),
260: 'RL1_PRE',hou.name,
261: 'RL1_ORG',hou1.name,
262: 'RL1_LOC',loc.location_code,null)
263: ,decode(pay_ca_rl2_reg.get_parameter('P_S2',ppa1.legislative_parameters),
264: 'RL1_PRE',hou.name,
265: 'RL1_ORG',hou1.name,
266: 'RL1_LOC',loc.location_code,null)
267: ,decode(pay_ca_rl2_reg.get_parameter('P_S3',ppa1.legislative_parameters),

Line 267: ,decode(pay_ca_rl2_reg.get_parameter('P_S3',ppa1.legislative_parameters),

263: ,decode(pay_ca_rl2_reg.get_parameter('P_S2',ppa1.legislative_parameters),
264: 'RL1_PRE',hou.name,
265: 'RL1_ORG',hou1.name,
266: 'RL1_LOC',loc.location_code,null)
267: ,decode(pay_ca_rl2_reg.get_parameter('P_S3',ppa1.legislative_parameters),
268: 'RL1_PRE',hou.name,
269: 'RL1_ORG',hou1.name,
270: 'RL1_LOC',loc.location_code,null)
271: ,ppf.last_name,ppf.first_name;