DBA Data[Home] [Help]

APPS.PAY_GB_BACS_TAPE dependencies on PER_TIME_PERIODS

Line 574: per_time_periods ptp

570: CURSOR csr_get_default_date IS
571: select default_dd_date
572: from pay_assignment_actions paa,
573: pay_payroll_actions ppa,
574: per_time_periods ptp
575: where paa.assignment_action_id =
576: p_assignment_action_id
577: and ppa.payroll_action_id =
578: paa.payroll_action_id

Line 587: per_time_periods ptp,

583: ptp.end_date,
584: decode(tpr.basic_period_type,'CM',tpr.periods_per_period,0)
585: from per_time_period_rules tpr,
586: per_time_period_types tpt,
587: per_time_periods ptp,
588: pay_payroll_actions ppa,
589: pay_assignment_actions paa
590: where paa.assignment_action_id = p_assignment_action_id
591: and ppa.payroll_action_id = paa.payroll_action_id