APPS.PAY_CA_T4_XML dependencies on PAY_CA_T4_REG

Line 147: decode(pay_ca_t4_reg.get_parameter

143: and ppf2.effective_start_date
144: <= ppa1.effective_date)
145: and ppf.effective_end_date >= ppa1.start_date
146: order by
147: decode(pay_ca_t4_reg.get_parameter
148: ('P_S1',ppa1.legislative_parameters),
149: 'GRE',hou1.name,
150: 'ORGANIZATION',hou.name,
151: 'LOCATION',loc.location_code,null),

Line 152: decode(pay_ca_t4_reg.get_parameter('P_S2',ppa1.legislative_parameters),

148: ('P_S1',ppa1.legislative_parameters),
149: 'GRE',hou1.name,
150: 'ORGANIZATION',hou.name,
151: 'LOCATION',loc.location_code,null),
152: decode(pay_ca_t4_reg.get_parameter('P_S2',ppa1.legislative_parameters),
153: 'GRE',hou1.name,
154: 'ORGANIZATION',hou.name,
155: 'LOCATION',loc.location_code,null),
156: decode(pay_ca_t4_reg.get_parameter('P_S3',ppa1.legislative_parameters),

Line 156: decode(pay_ca_t4_reg.get_parameter('P_S3',ppa1.legislative_parameters),

152: decode(pay_ca_t4_reg.get_parameter('P_S2',ppa1.legislative_parameters),
153: 'GRE',hou1.name,
154: 'ORGANIZATION',hou.name,
155: 'LOCATION',loc.location_code,null),
156: decode(pay_ca_t4_reg.get_parameter('P_S3',ppa1.legislative_parameters),
157: 'GRE',hou1.name,
158: 'ORGANIZATION',hou.name,
159: 'LOCATION',loc.location_code,null),
160: ppf.last_name,first_name;