APPS.PAY_GB_BACS_TAPE dependencies on PER_TIME_PERIODS

Line 292: from per_time_periods ptp,

288: 'TRANSFER_CURRENCY_CODE=P',
289: popm.currency_code,
290: 'ORG_PAY_METHOD_NAME=P',
291: popm.ORG_PAYMENT_METHOD_NAME
292: from per_time_periods ptp,
293: pay_payroll_actions ppa,
294: pay_assignment_actions paa2,
295: pay_org_payment_methods popm,
296: pay_pre_payments ppp,

Line 373: per_time_periods ptp,

369: )
370: union
371: select 1
372: from
373: per_time_periods ptp,
374: pay_payroll_actions ppa,
375: pay_assignment_actions paa
376: where paa.assignment_action_id =
377: (select max(pai.locked_action_id)

Line 632: from per_time_periods ptp,

628: to_date(pay_magtape_generic.get_parameter_value(
629: 'TRANSFER_BACS_PROCESS_DATE'),'YYYY/MM/DD HH24:MI:SS')), 'YYDDD'),
630: 'TRANSFER_BUREAU_NO=P', org.pmeth_information3,
631: 'ORG_PAY_METHOD_NAME=P', org.org_payment_method_name
632: from per_time_periods ptp,
633: pay_payroll_actions ppa,
634: pay_assignment_actions paa2,
635: pay_org_payment_methods org,
636: pay_pre_payments ppp,

Line 719: per_time_periods ptp,

715: )
716: union
717: select 1
718: from
719: per_time_periods ptp,
720: pay_payroll_actions ppa,
721: pay_assignment_actions paa
722: where paa.assignment_action_id =
723: (select max(pai.locked_action_id)