DBA Data[Home] [Help]

APPS.PAY_AU_SOE_PKG dependencies on PER_TIME_PERIODS

Line 571: per_time_periods ptp,

567: rppa.pay_advice_message
568: from pay_assignment_actions paa,
569: pay_payroll_actions ppa,
570: pay_assignment_actions rpaa,
571: per_time_periods ptp,
572: pay_payroll_actions rppa
573: where paa.payroll_action_id = ppa.payroll_action_id
574: and rppa.payroll_action_id = rpaa.payroll_action_id
575: and rppa.time_period_id = ptp.time_period_id

Line 669: per_time_periods ptp

665: nvl(pact.pay_advice_date,ptp.pay_advice_date),
666: pay_advice_message
667: from pay_assignment_actions assact,
668: pay_payroll_actions pact,
669: per_time_periods ptp
670: where assact.assignment_action_id = p_run_assignment_action_id
671: and pact.payroll_action_id = assact.payroll_action_id
672: and pact.payroll_id = ptp.payroll_id
673: and pact.date_earned between ptp.start_date and ptp.end_date ;