[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT overriding_dd_date
FROM pay_payroll_actions
WHERE business_group_id = cp_business_group_id
AND payroll_action_id = cp_payroll_action_id
AND payroll_id = NVL (cp_payroll_id, payroll_id)
AND consolidation_set_id =
NVL (cp_consolidation_set_id, consolidation_set_id)
AND org_payment_method_id =
NVL (cp_org_payment_method_id, org_payment_method_id)
AND effective_date = NVL (cp_effective_date, effective_date)
AND date_earned = NVL (cp_date_earned, date_earned);
SELECT NVL (ppa_chk.overriding_dd_date, ppa_pre.effective_date)
FROM pay_payroll_actions ppa_chk,
pay_assignment_actions paa_chk,
pay_payroll_actions ppa_pre,
pay_assignment_actions paa_pre,
pay_action_interlocks pai,
pay_pre_payments ppp
WHERE ppa_chk.payroll_action_id = cp_payroll_action_id
AND ppa_chk.business_group_id = cp_business_group_id
AND ppa_chk.payroll_id = NVL (cp_payroll_id, ppa_chk.payroll_id)
AND ppa_chk.consolidation_set_id =
NVL (cp_consolidation_set_id, ppa_chk.consolidation_set_id)
AND ppa_chk.org_payment_method_id =
NVL (cp_org_payment_method_id, ppa_chk.org_payment_method_id)
AND ppa_chk.effective_date =
NVL (cp_effective_date, ppa_chk.effective_date)
AND ppa_chk.date_earned = NVL (cp_date_earned, ppa_chk.date_earned)
AND ppa_chk.action_type = 'H'
AND ppa_chk.payroll_action_id = paa_chk.payroll_action_id
AND paa_chk.action_status = 'C'
AND paa_chk.assignment_action_id = pai.locking_action_id
AND pai.locked_action_id = paa_pre.assignment_action_id
AND paa_pre.payroll_action_id = ppa_pre.payroll_action_id
AND paa_pre.action_status = 'C'
AND ppa_pre.action_type IN ('P', 'U')
AND paa_pre.assignment_action_id = ppp.assignment_action_id
AND ppp.pre_payment_id = NVL (cp_pre_payment_id, ppp.pre_payment_id)
AND ppp.pre_payment_id = paa_chk.pre_payment_id
AND ppp.org_payment_method_id = ppa_chk.org_payment_method_id;
SELECT ppa.effective_date
FROM pay_pre_payments ppp,
pay_assignment_actions paa,
pay_payroll_actions ppa
WHERE ppp.pre_payment_id = cp_pre_payment_id
AND ppp.assignment_action_id = paa.assignment_action_id
AND paa.payroll_action_id = ppa.payroll_action_id
AND ppa.action_type IN ('P', 'U');