APPS.PAY_NL_PAYFILE_SEPA dependencies on PAY_NL_GENERAL

Line 72: ,to_char(fnd_date.canonical_to_date(pay_nl_general.get_parameter(

68: ,NULL
69: ,'CREATION_DATE=P'
70: ,to_char(ppa.effective_date, 'RRRR-MM-DD"T"HH24:MI:SS')
71: ,'PROCESS_DATE=P'
72: ,to_char(fnd_date.canonical_to_date(pay_nl_general.get_parameter(
73: ppa.legislative_parameters,
74: 'PROCESS_DATE')), 'RRRR-MM-DD')
75: ,'BATCH_BOOKING=P'
76: ,decode(pay_nl_general.get_parameter(ppa.legislative_parameters,'BATCH_BOOKING'),'Y','TRUE','N','FALSE','TRUE')

Line 76: ,decode(pay_nl_general.get_parameter(ppa.legislative_parameters,'BATCH_BOOKING'),'Y','TRUE','N','FALSE','TRUE')

72: ,to_char(fnd_date.canonical_to_date(pay_nl_general.get_parameter(
73: ppa.legislative_parameters,
74: 'PROCESS_DATE')), 'RRRR-MM-DD')
75: ,'BATCH_BOOKING=P'
76: ,decode(pay_nl_general.get_parameter(ppa.legislative_parameters,'BATCH_BOOKING'),'Y','TRUE','N','FALSE','TRUE')
77: ,'TRANSFER_ORG_PAY_METHOD_ID=P'
78: ,to_char(ppa.org_payment_method_id)
79: ,'DATE_EARNED=C'
80: ,to_char(ppa.effective_date, 'RRRR/MM/DD HH24:MI:SS')

Line 90: ,NVL(pay_nl_general.get_parameter(ppa.legislative_parameters,'INSTR_IDENT'),' ')

86: ,'0'
87: ,'TRANSFER_ERROR_FLAG=P'
88: ,'N'
89: ,'INSTR_IDENT=P'
90: ,NVL(pay_nl_general.get_parameter(ppa.legislative_parameters,'INSTR_IDENT'),' ')
91: FROM pay_payroll_actions ppa
92: WHERE ppa.payroll_action_id =
93: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
94: AND EXISTS (

Line 110: ,to_char(fnd_date.canonical_to_date(pay_nl_general.get_parameter(

106: SELECT 'PARA_PMNT1=P'
107: --To print the closing tag correctlty in case of multiple Employers.
108: ,to_char(hou.organization_id)||to_char(pea.external_account_id)||to_char(hoi.org_information4)
109: ,'REQ_EXEC_DATE=P'
110: ,to_char(fnd_date.canonical_to_date(pay_nl_general.get_parameter(
111: ppa.legislative_parameters,
112: 'PROCESS_DATE')), 'RRRR-MM-DD')
113: ,'DBTR_NAME=P'
114: ,hou.name

Line 177: Group by to_char(fnd_date.canonical_to_date(pay_nl_general.get_parameter(

173: AND ppf.prl_information_category = 'NL'
174: AND ppa.effective_date between paaf.effective_start_date and paaf.effective_end_date
175: AND ppa.effective_date between ppf.effective_start_date and ppf.effective_end_date
176: )
177: Group by to_char(fnd_date.canonical_to_date(pay_nl_general.get_parameter(
178: ppa.legislative_parameters,
179: 'PROCESS_DATE')), 'RRRR-MM-DD')
180: ,hou.name
181: ,hou.organization_id

Line 193: ,NVL(min(pay_nl_general.get_parameter(ppa.legislative_parameters,'SEPA_CATEGORY')),'SALA')

189: * Cursor to fetch transaction record information *
190: ********************************************************/
191: CURSOR CSR_NL_TRAN_INFO IS
192: SELECT 'SEPA_CATG=P'
193: ,NVL(min(pay_nl_general.get_parameter(ppa.legislative_parameters,'SEPA_CATEGORY')),'SALA')
194: ,'AMOUNT=P'
195: ,to_char (sum (ppp.value * 100), 'FM999999999999999999999009')
196: ,'FIRST_NAME=P'
197: , substr(min(pef.first_name),1,70)

Line 205: ,decode(min(pay_nl_general.chk_multiple_assignments(ppa.effective_date,paf.person_id))

201: ,substr(min(pef.per_information1),1,70)
202: ,'EMP_NO=P'
203: , nvl(min(pef.employee_number),' ')
204: ,'ASG_NO=P'
205: ,decode(min(pay_nl_general.chk_multiple_assignments(ppa.effective_date,paf.person_id))
206: ,'Y',nvl(min(paf.assignment_number),' ')
207: ,'N', ' ')
208: ,'ASSIGNMENT_ID=C'
209: , min(paf.assignment_id)

Line 254: ORDER BY decode(min(pay_nl_general.get_parameter(legislative_parameters,

250: AND ppa.effective_date BETWEEN ppmf.effective_start_date
251: AND ppmf.effective_end_date
252: GROUP BY
253: pef.person_id, pea.SEGMENT10, pea.SEGMENT9
254: ORDER BY decode(min(pay_nl_general.get_parameter(legislative_parameters,
255: 'SORT_ORDER')),
256: 'NAME', substr(min(pef.last_name) || ' ' || min(pef.first_name),1,30),
257: 'NUMBER', min(pef.employee_number), null);
258: