DBA Data[Home] [Help]

APPS.PAY_NZ_SOE_PKG dependencies on PER_TIME_PERIODS

Line 518: per_time_periods ptp,

514: rppa.pay_advice_message
515: from pay_assignment_actions paa,
516: pay_payroll_actions ppa,
517: pay_assignment_actions rpaa,
518: per_time_periods ptp,
519: pay_payroll_actions rppa
520: where paa.payroll_action_id = ppa.payroll_action_id
521: and rppa.payroll_action_id = rpaa.payroll_action_id
522: and rppa.time_period_id = ptp.time_period_id

Line 615: per_time_periods ptp

611: nvl(pact.pay_advice_date,ptp.pay_advice_date),
612: pay_advice_message
613: from pay_assignment_actions assact,
614: pay_payroll_actions pact,
615: per_time_periods ptp
616: where assact.assignment_action_id = p_run_assignment_action_id
617: and pact.payroll_action_id = assact.payroll_action_id
618: and pact.time_period_id = ptp.time_period_id ;
619: --