APPS.PAY_SA_EFT dependencies on PAY_SA_GENERAL

Line 122: ,to_char(fnd_date.canonical_to_date(pay_sa_general.get_parameter(

118: SELECT 'CREATION_DATE=P'
119: ,to_char(ppa.effective_date, 'YYYYMMDD')
120:
121: ,'PROCESS_DATE=P'
122: ,to_char(fnd_date.canonical_to_date(pay_sa_general.get_parameter(
123: ppa.legislative_parameters,
124: 'PROCESS_DATE')), 'YYYYMMDD')
125: ,'DATE_EARNED=C'
126: ,to_char(ppa.effective_date, 'YYYY/MM/DD HH24:MI:SS')

Line 136: ,pay_sa_general.get_count

132: ,ppa.payroll_id
133: ,'PAYROLL_ACTION_ID=C'
134: ,ppa.payroll_action_id
135: ,'COUNT1=P'
136: ,pay_sa_general.get_count
137: ,'SUM1=P'
138: ,pay_sa_general.get_sum * 100
139: FROM pay_payroll_actions ppa
140: WHERE ppa.payroll_action_id =

Line 138: ,pay_sa_general.get_sum * 100

134: ,ppa.payroll_action_id
135: ,'COUNT1=P'
136: ,pay_sa_general.get_count
137: ,'SUM1=P'
138: ,pay_sa_general.get_sum * 100
139: FROM pay_payroll_actions ppa
140: WHERE ppa.payroll_action_id =
141: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
142: AND EXISTS (

Line 165: ,decode(pay_sa_general.chk_multiple_assignments(ppa.effective_date,paf.person_id)

161: ,substr(pef.per_information1,1,35)
162: ,'EMP_NO=P'
163: , nvl(pef.employee_number,' ')
164: ,'ASG_NO=P'
165: ,decode(pay_sa_general.chk_multiple_assignments(ppa.effective_date,paf.person_id)
166: ,'Y',nvl(paf.assignment_number,' ')
167: ,'N', ' ')
168: ,'ASSIGNMENT_ID=C' , paf.assignment_id
169: ,'BUSINESS_GROUP_ID=C' , paf.business_group_id

Line 180: ,pay_sa_general.get_parameter(ppa.legislative_parameters,

176: ,'ORGANIZATION_ID=C' , paf.organization_id
177: ,'TAX_UNIT_ID=C' , paa.tax_unit_id
178:
179: ,'LOCAL_NATIONALITY=P'
180: ,pay_sa_general.get_parameter(ppa.legislative_parameters,
181: 'LOCAL_NATIONALITY')
182: FROM per_assignments_f paf
183: ,per_people_f pef
184: ,pay_pre_payments ppp

Line 198: ORDER BY decode(pay_sa_general.get_parameter(legislative_parameters,

194: AND ppa.effective_date BETWEEN paf.effective_start_date
195: AND paf.effective_end_date
196: AND ppa.effective_date BETWEEN pef.effective_start_date
197: AND pef.effective_end_date
198: ORDER BY decode(pay_sa_general.get_parameter(legislative_parameters,
199: 'SORT_ORDER'),
200: 'NAME', substr(pef.last_name || ' ' || pef.first_name,1,50),
201: 'NUMBER', pef.employee_number, null);
202: END PAY_SA_EFT;