APPS.PAY_KW_EFT dependencies on PAY_KW_GENERAL

Line 115: ,to_char(fnd_date.canonical_to_date(pay_kw_general.get_parameter(

111: CURSOR CSR_KW_EFT_HEADER IS
112: SELECT 'CREATION_DATE=P'
113: ,to_char(ppa.effective_date, 'DDMMYYYY')
114: ,'PROCESS_DATE=P'
115: ,to_char(fnd_date.canonical_to_date(pay_kw_general.get_parameter(
116: ppa.legislative_parameters,
117: 'PROCESS_DATE')), 'DDMMYYYY')
118: ,'DATE_EARNED=C'
119: ,to_char(ppa.effective_date, 'YYYY/MM/DD HH24:MI:SS')

Line 129: ,pay_kw_general.get_count

125: ,ppa.payroll_id
126: ,'PAYROLL_ACTION_ID=C'
127: ,ppa.payroll_action_id
128: ,'COUNT1=P'
129: ,pay_kw_general.get_count
130: ,'SUM1=P'
131: ,pay_kw_general.get_sum * 1000
132: FROM pay_payroll_actions ppa
133: WHERE ppa.payroll_action_id =

Line 131: ,pay_kw_general.get_sum * 1000

127: ,ppa.payroll_action_id
128: ,'COUNT1=P'
129: ,pay_kw_general.get_count
130: ,'SUM1=P'
131: ,pay_kw_general.get_sum * 1000
132: FROM pay_payroll_actions ppa
133: WHERE ppa.payroll_action_id =
134: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
135: AND EXISTS (

Line 157: ,decode(pay_kw_general.chk_multiple_assignments(ppa.effective_date,paf.person_id)

153: ,substr(pef.per_information1,1,35)
154: ,'EMP_NO=P'
155: , nvl(pef.employee_number,' ')
156: ,'ASG_NO=P'
157: ,decode(pay_kw_general.chk_multiple_assignments(ppa.effective_date,paf.person_id)
158: ,'Y',nvl(paf.assignment_number,' ')
159: ,'N', ' ')
160: ,'ASSIGNMENT_ID=C' , paf.assignment_id
161: ,'BUSINESS_GROUP_ID=C' , paf.business_group_id

Line 171: ,pay_kw_general.get_parameter(ppa.legislative_parameters,

167: ,'ASSIGNMENT_ACTION_ID=C', ppa.org_payment_method_id
168: ,'ORGANIZATION_ID=C' , paf.organization_id
169: ,'TAX_UNIT_ID=C' , paa.tax_unit_id
170: ,'LOCAL_NATIONALITY=P'
171: ,pay_kw_general.get_parameter(ppa.legislative_parameters,
172: 'LOCAL_NATIONALITY')
173: FROM per_assignments_f paf
174: ,per_people_f pef
175: ,pay_pre_payments ppp

Line 189: ORDER BY decode(pay_kw_general.get_parameter(legislative_parameters,

185: AND ppa.effective_date BETWEEN paf.effective_start_date
186: AND paf.effective_end_date
187: AND ppa.effective_date BETWEEN pef.effective_start_date
188: AND pef.effective_end_date
189: ORDER BY decode(pay_kw_general.get_parameter(legislative_parameters,
190: 'SORT_ORDER'),
191: 'NAME', substr(pef.last_name || ' ' || pef.first_name,1,50),
192: 'NUMBER', pef.employee_number, null);
193: END PAY_KW_EFT;