APPS.PAY_GB_BACS_TAPE dependencies on PER_TIME_PERIODS

Line 290: from per_time_periods ptp,

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

Line 371: per_time_periods ptp,

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

Line 630: from per_time_periods ptp,

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

Line 717: per_time_periods ptp,

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