DBA Data[Home] [Help]

APPS.PAY_KR_SAMPLE_SEP_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 431: pay_assignment_actions paa

427: per_assignment_status_types past,
428: per_assignments_f pa,
429: pay_payroll_actions ppa,
430: pay_run_types_f prt,
431: pay_assignment_actions paa
432: where paa.assignment_id = p_assignment_id
433: and paa.action_status = 'C'
434: and prt.run_type_id = paa.run_type_id
435: and p_effective_date

Line 558: pay_assignment_actions paa,

554: per_assignment_status_types past,
555: per_assignments_f pa,
556: pay_payroll_actions ppa,
557: pay_run_types_f prt,
558: pay_assignment_actions paa,
559: -- per_time_periods bptp,
560: pay_payroll_actions bppa,
561: pay_assignment_actions bpaa
562: where bpaa.assignment_action_id = p_assignment_action_id

Line 561: pay_assignment_actions bpaa

557: pay_run_types_f prt,
558: pay_assignment_actions paa,
559: -- per_time_periods bptp,
560: pay_payroll_actions bppa,
561: pay_assignment_actions bpaa
562: where bpaa.assignment_action_id = p_assignment_action_id
563: and bppa.payroll_action_id = bpaa.payroll_action_id
564: -- and bptp.time_period_id = bppa.time_period_id
565: and paa.assignment_id = bpaa.assignment_id

Line 596: pay_assignment_actions rpaa,

592: and ppa.action_type <> 'V'
593: and not exists(
594: select null
595: from pay_payroll_actions rppa,
596: pay_assignment_actions rpaa,
597: pay_action_interlocks pai
598: where pai.locked_action_id = paa.assignment_action_id
599: and rpaa.assignment_action_id = pai.locking_action_id
600: and rppa.payroll_action_id = rpaa.payroll_action_id