DBA Data[Home] [Help]

APPS.PAY_GB_BACS_TAPE dependencies on FND_SESSIONS

Line 135: from fnd_sessions fnd,

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

Line 213: from fnd_sessions fnd,

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

Line 418: from fnd_sessions fnd,

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

Line 445: from fnd_sessions fnd,

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

Line 521: from fnd_sessions fnd,

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

Line 548: from fnd_sessions fnd,

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