DBA Data[Home] [Help]

APPS.PAY_CA_T4A_XML dependencies on PAY_CA_T4_REG

Line 103: decode(pay_ca_t4_reg.get_parameter

99: <= ppa1.effective_date)
100: and ppf.effective_end_date >= ppa1.start_date
101: order by
102:
103: decode(pay_ca_t4_reg.get_parameter
104: ('P_S1',ppa1.legislative_parameters),
105: 'GRE',hou1.name,
106: 'ORGANIZATION',hou.name,
107: 'LOCATION',loc.location_code,null),

Line 108: decode(pay_ca_t4_reg.get_parameter('P_S2',

104: ('P_S1',ppa1.legislative_parameters),
105: 'GRE',hou1.name,
106: 'ORGANIZATION',hou.name,
107: 'LOCATION',loc.location_code,null),
108: decode(pay_ca_t4_reg.get_parameter('P_S2',
109: ppa1.legislative_parameters),
110: 'GRE',hou1.name,
111: 'ORGANIZATION',hou.name,
112: 'LOCATION',loc.location_code,null),

Line 113: decode(pay_ca_t4_reg.get_parameter('P_S3',

109: ppa1.legislative_parameters),
110: 'GRE',hou1.name,
111: 'ORGANIZATION',hou.name,
112: 'LOCATION',loc.location_code,null),
113: decode(pay_ca_t4_reg.get_parameter('P_S3',
114: ppa1.legislative_parameters),
115: 'GRE',hou1.name,
116: 'ORGANIZATION',hou.name,
117: 'LOCATION',loc.location_code,null),