APPS.PAY_CA_RL1_MAG dependencies on PAY_CA_RL1_REG

Line 78: pay_ca_rl1_reg.get_parameter('PRE_ORGANIZATION_ID', ppa.legislative_parameters)

74: WHERE decode(hoi.org_information3,'Y',to_char(hoi.organization_id) ,hoi.org_information20) =
75: pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
76: and hoi.org_information_context='Prov Reporting Est'
77: and to_char(hoi.organization_id) =
78: pay_ca_rl1_reg.get_parameter('PRE_ORGANIZATION_ID', ppa.legislative_parameters)
79: and ppa.action_status = 'C'
80: and to_char(ppa.effective_date,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
81: and to_char(ppa.effective_date,'DD-MM') = '31-12'
82: and ppa.report_type = 'RL1';

Line 264: decode(pay_ca_rl1_reg.get_parameter('P_S1',ppa1.legislative_parameters),

260: from per_all_assignments_f paaf2
261: where paaf2.assignment_id = paf.assignment_id
262: and paaf2.effective_start_date <= ppa1.effective_date)
263: order by
264: decode(pay_ca_rl1_reg.get_parameter('P_S1',ppa1.legislative_parameters),
265: 'RL1_PRE',hou.name,
266: 'RL1_ORG',hou1.name,
267: 'RL1_LOC',loc.location_code,null)
268: ,decode(pay_ca_rl1_reg.get_parameter('P_S2',ppa1.legislative_parameters),

Line 268: ,decode(pay_ca_rl1_reg.get_parameter('P_S2',ppa1.legislative_parameters),

264: decode(pay_ca_rl1_reg.get_parameter('P_S1',ppa1.legislative_parameters),
265: 'RL1_PRE',hou.name,
266: 'RL1_ORG',hou1.name,
267: 'RL1_LOC',loc.location_code,null)
268: ,decode(pay_ca_rl1_reg.get_parameter('P_S2',ppa1.legislative_parameters),
269: 'RL1_PRE',hou.name,
270: 'RL1_ORG',hou1.name,
271: 'RL1_LOC',loc.location_code,null)
272: ,decode(pay_ca_rl1_reg.get_parameter('P_S3',ppa1.legislative_parameters),

Line 272: ,decode(pay_ca_rl1_reg.get_parameter('P_S3',ppa1.legislative_parameters),

268: ,decode(pay_ca_rl1_reg.get_parameter('P_S2',ppa1.legislative_parameters),
269: 'RL1_PRE',hou.name,
270: 'RL1_ORG',hou1.name,
271: 'RL1_LOC',loc.location_code,null)
272: ,decode(pay_ca_rl1_reg.get_parameter('P_S3',ppa1.legislative_parameters),
273: 'RL1_PRE',hou.name,
274: 'RL1_ORG',hou1.name,
275: 'RL1_LOC',loc.location_code,null)
276: ,ppf.last_name,ppf.first_name;