APPS.PAY_NL_PAYFILE dependencies on PAY_NL_GENERAL

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

44: CURSOR CSR_NL_PAYFILE_HEADER IS
45: SELECT 'CREATION_DATE=P'
46: ,to_char(ppa.effective_date, 'DDMMYY')
47: ,'PROCESS_DATE=P'
48: ,to_char(fnd_date.canonical_to_date(pay_nl_general.get_parameter(
49: ppa.legislative_parameters,
50: 'PROCESS_DATE')), 'DDMMYY')
51: ,'FILE_ID=P'
52: , pay_nl_general.get_file_id(ppa.effective_date)

Line 52: , pay_nl_general.get_file_id(ppa.effective_date)

48: ,to_char(fnd_date.canonical_to_date(pay_nl_general.get_parameter(
49: ppa.legislative_parameters,
50: 'PROCESS_DATE')), 'DDMMYY')
51: ,'FILE_ID=P'
52: , pay_nl_general.get_file_id(ppa.effective_date)
53: ,'BATCH_DESCRIPTION=P'
54: ,nvl(pay_nl_general.get_parameter(ppa.legislative_parameters, 'BATCH_DESC'),' ')
55: ,'USER_NAME=P'
56: ,pay_nl_general.get_parameter(ppa.legislative_parameters, 'USER_NAME')

Line 54: ,nvl(pay_nl_general.get_parameter(ppa.legislative_parameters, 'BATCH_DESC'),' ')

50: 'PROCESS_DATE')), 'DDMMYY')
51: ,'FILE_ID=P'
52: , pay_nl_general.get_file_id(ppa.effective_date)
53: ,'BATCH_DESCRIPTION=P'
54: ,nvl(pay_nl_general.get_parameter(ppa.legislative_parameters, 'BATCH_DESC'),' ')
55: ,'USER_NAME=P'
56: ,pay_nl_general.get_parameter(ppa.legislative_parameters, 'USER_NAME')
57: ,'DATE_EARNED=C'
58: ,to_char(ppa.effective_date, 'YYYY/MM/DD HH24:MI:SS')

Line 56: ,pay_nl_general.get_parameter(ppa.legislative_parameters, 'USER_NAME')

52: , pay_nl_general.get_file_id(ppa.effective_date)
53: ,'BATCH_DESCRIPTION=P'
54: ,nvl(pay_nl_general.get_parameter(ppa.legislative_parameters, 'BATCH_DESC'),' ')
55: ,'USER_NAME=P'
56: ,pay_nl_general.get_parameter(ppa.legislative_parameters, 'USER_NAME')
57: ,'DATE_EARNED=C'
58: ,to_char(ppa.effective_date, 'YYYY/MM/DD HH24:MI:SS')
59: ,'ORG_PAY_METHOD_ID=C'
60: ,ppa.org_payment_method_id

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

86: ,substr(min(pef.per_information1),1,35)
87: ,'EMP_NO=P'
88: , nvl(min(pef.employee_number),' ')
89: ,'ASG_NO=P'
90: ,decode(min(pay_nl_general.chk_multiple_assignments(ppa.effective_date,paf.person_id))
91: ,'Y',nvl(min(paf.assignment_number),' ')
92: ,'N', ' ')
93: ,'SUPPRESS_PAYEE_RECORD=P'
94: ,min(pay_nl_general.get_parameter(ppa.legislative_parameters,'SUPPRESS_PAYEE_RECORD'))

Line 94: ,min(pay_nl_general.get_parameter(ppa.legislative_parameters,'SUPPRESS_PAYEE_RECORD'))

90: ,decode(min(pay_nl_general.chk_multiple_assignments(ppa.effective_date,paf.person_id))
91: ,'Y',nvl(min(paf.assignment_number),' ')
92: ,'N', ' ')
93: ,'SUPPRESS_PAYEE_RECORD=P'
94: ,min(pay_nl_general.get_parameter(ppa.legislative_parameters,'SUPPRESS_PAYEE_RECORD'))
95: ,'ASSIGNMENT_ID=C'
96: , min(paf.assignment_id)
97: ,'BUSINESS_GROUP_ID=C'
98: , min(paf.business_group_id)

Line 133: Group by decode (pay_nl_general.get_parameter (legislative_parameters,

129: account number for an employee.This will group the payments
130: by account number and person id if the user wishes to consolidate
131: else it will group by assignment id */
132:
133: Group by decode (pay_nl_general.get_parameter (legislative_parameters,
134: 'ACCOUNTNO_CONSOLIDATION'),'Y', (lpad(pef.person_id,10,0) ||lpad(pea.segment2,10,0)),
135: (lpad(paf.assignment_id,10,0)||lpad(pea.segment2,10,0)))
136:
137: ORDER BY decode(min(pay_nl_general.get_parameter(legislative_parameters,

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

133: Group by decode (pay_nl_general.get_parameter (legislative_parameters,
134: 'ACCOUNTNO_CONSOLIDATION'),'Y', (lpad(pef.person_id,10,0) ||lpad(pea.segment2,10,0)),
135: (lpad(paf.assignment_id,10,0)||lpad(pea.segment2,10,0)))
136:
137: ORDER BY decode(min(pay_nl_general.get_parameter(legislative_parameters,
138: 'SORT_ORDER')),
139: 'NAME', substr(min(pef.last_name) || ' ' || min(pef.first_name),1,30),
140: 'NUMBER', min(pef.employee_number), null);
141: END PAY_NL_PAYFILE;