DBA Data[Home] [Help]

APPS.PAY_ZA_IRP5_MAGTAPE_PKG dependencies on PY_ZA_TAX_CERTIFICATES

Line 75: and py_za_tax_certificates.irp5_indicator(paa.assignment_action_id) in ('Y','N') -- 6166892

71: and paa.assignment_id = paei.assignment_id
72: and to_char(haou.organization_id) = paei.aei_information7
73: and paei.aei_information_category = 'ZA_SPECIFIC_INFO'
74: and paa.serial_number is not null
75: and py_za_tax_certificates.irp5_indicator(paa.assignment_action_id) in ('Y','N') -- 6166892
76: and substr(paa.serial_number, 1, 1) in ('0','1','2','3','4','5','6','7','8','9')
77: )
78: order by haou.organization_id;
79:

Line 135: and py_za_tax_certificates.irp5_indicator(paa.assignment_action_id) in ('Y','N') -- 6166892

131: pay_magtape_generic.get_parameter_value('TAX_YEAR')
132: and paa.payroll_action_id = ppa.payroll_action_id
133: and paa.assignment_id = paei.assignment_id
134: and paa.serial_number is not null
135: and py_za_tax_certificates.irp5_indicator(paa.assignment_action_id) in ('Y','N') -- 6166892
136: and substr(paa.serial_number, 1, 1) in ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9')
137: and pef.assignment_id = paa.assignment_id
138: and ppf.person_id = pef.person_id
139: and ppf.per_information_category = 'ZA'