DBA Data[Home] [Help]

APPS.PAY_GB_BACS_TAPE dependencies on FND_SESSIONS

Line 137: from fnd_sessions fnd,

133: 'TRANSFER_BACS_PROCESS_DATE=P',
134: to_char(ppa.overriding_dd_date, 'YYYY/MM/DD HH24:MI:SS'),
135: 'TRANSFER_FORMAT_TYPE=P',
136: substr(ppa.LEGISLATIVE_PARAMETERS,instr(LEGISLATIVE_PARAMETERS,'FORMAT_TYPE=')+12,1)
137: from fnd_sessions fnd,
138: pay_pre_payments ppp,
139: pay_assignment_actions paa,
140: pay_payroll_actions ppa
141: where paa.payroll_action_id =

Line 215: from fnd_sessions fnd,

211: 'TRANSFER_BACS_PROCESS_DATE2=P',
212: to_char(ppa.overriding_dd_date, 'YYDDD'),
213: 'TRANSFER_FORMAT_TYPE=P',
214: substr(ppa.LEGISLATIVE_PARAMETERS,instr(LEGISLATIVE_PARAMETERS,'FORMAT_TYPE=')+12,1)
215: from fnd_sessions fnd,
216: pay_pre_payments ppp,
217: pay_assignment_actions paa,
218: pay_payroll_actions ppa
219: where paa.payroll_action_id =

Line 420: from fnd_sessions fnd,

416: 'TRANSFER_FIRST_BUREAU_NO=P',
417: org.pmeth_information3,
418: 'TRANSFER_FORMAT_TYPE=P',
419: substr(ppa.LEGISLATIVE_PARAMETERS,instr(LEGISLATIVE_PARAMETERS,'FORMAT_TYPE=')+12,1)
420: from fnd_sessions fnd,
421: PAY_ORG_PAYMENT_METHODS org,
422: pay_pre_payments ppp,
423: pay_assignment_actions paa,
424: pay_payroll_actions ppa

Line 447: from fnd_sessions fnd,

443: 'TRANSFER_CURRENCY_CODE=P',
444: org.currency_code,
445: 'ORG_PAY_METHOD_NAME=P',
446: min(org.org_payment_method_name)
447: from fnd_sessions fnd,
448: pay_org_payment_methods org,
449: pay_pre_payments ppp,
450: pay_assignment_actions paa,
451: pay_payroll_actions ppa

Line 523: from fnd_sessions fnd,

519: 'TRANSFER_FIRST_BUREAU_NO=P',
520: org.pmeth_information3,
521: 'TRANSFER_FORMAT_TYPE=P',
522: substr(ppa.LEGISLATIVE_PARAMETERS,instr(LEGISLATIVE_PARAMETERS,'FORMAT_TYPE=')+12,1)
523: from fnd_sessions fnd,
524: PAY_ORG_PAYMENT_METHODS org,
525: pay_pre_payments ppp,
526: pay_payroll_actions ppa,
527: pay_assignment_actions paa

Line 550: from fnd_sessions fnd,

546: 'TRANSFER_CURRENCY_CODE=P',
547: org.currency_code,
548: 'ORG_PAY_METHOD_NAME=P',
549: min(org.org_payment_method_name)
550: from fnd_sessions fnd,
551: pay_org_payment_methods org,
552: pay_pre_payments ppp,
553: pay_payroll_actions ppa,
554: pay_assignment_actions paa