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 166: ,decode(pay_sa_general.chk_multiple_assignments(ppa.effective_date,paf.person_id)

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

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

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

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

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