DBA Data[Home] [Help]

APPS.PAY_NO_ARC_RSEA_07 dependencies on HR_SOFT_CODING_KEYFLEX

Line 448: ,hr_soft_coding_keyflex hsck

444: ,pay_assignment_actions act
445: ,pay_assignment_actions act1
446: ,pay_action_interlocks pai
447: ,per_all_assignments_f as1
448: ,hr_soft_coding_keyflex hsck
449: WHERE ppa.payroll_action_id = p_payroll_action_id
450: AND appa.effective_date BETWEEN l_start_date AND l_end_date
451: AND appa.action_type IN ('R','Q')
452: -- Payroll Run or Quickpay Run

Line 502: ,hr_soft_coding_keyflex hsck

498: ,pay_assignment_actions act
499: ,pay_assignment_actions act1
500: ,pay_action_interlocks pai
501: ,per_all_assignments_f as1
502: ,hr_soft_coding_keyflex hsck
503: WHERE ppa.payroll_action_id = p_payroll_action_id
504: AND appa.effective_date BETWEEN l_start_date AND l_end_date
505: AND appa.action_type IN ('R','Q')
506: -- Payroll Run or Quickpay Run

Line 535: hr_soft_coding_keyflex hsck

531: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id
532: FROM pay_assignment_actions paa,
533: pay_payroll_actions ppa,
534: per_all_assignments_f paaf,
535: hr_soft_coding_keyflex hsck
536: WHERE ppa.payroll_action_id = paa.payroll_action_id
537: and paa.assignment_id = paaf.assignment_id
538: and ppa.action_type in ('R','Q')
539: and paa.source_action_id is null