[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT TO_NUMBER
(SUBSTR
(pay_se_holiday_pay_debt.get_parameter
(legislative_parameters
, 'LEGAL_EMPLOYER'
)
, 1
, LENGTH
(pay_se_holiday_pay_debt.get_parameter
(legislative_parameters
, 'LEGAL_EMPLOYER'
)
)
- 1
)
) legal
, SUBSTR
(pay_se_holiday_pay_debt.get_parameter
(legislative_parameters
, 'REQUEST_FOR'
)
, 1
, LENGTH
(pay_se_holiday_pay_debt.get_parameter
(legislative_parameters
, 'REQUEST_FOR'
)
)
- 1
) request_for
, (pay_se_holiday_pay_debt.get_parameter
(legislative_parameters
, 'EFFECTIVE_START_DATE'
)
) eff_start_date
, (pay_se_holiday_pay_debt.get_parameter
(legislative_parameters
, 'EFFECTIVE_END_DATE'
)
) eff_end_date
, effective_date effective_date, business_group_id bg_id
FROM pay_payroll_actions
WHERE payroll_action_id = p_payroll_action_id;
SELECT o1.NAME legal_employer_name
, hoi2.org_information2 org_number
, hoi1.organization_id legal_id
FROM hr_organization_units o1
, hr_organization_information hoi1
, hr_organization_information hoi2
WHERE o1.business_group_id = g_business_group_id
AND hoi1.organization_id = o1.organization_id
AND hoi1.organization_id =
NVL (csr_v_legal_employer_id, hoi1.organization_id)
AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
AND hoi1.org_information_context = 'CLASS'
AND o1.organization_id = hoi2.organization_id
AND hoi2.org_information_context = 'SE_LEGAL_EMPLOYER_DETAILS';
SELECT '1'
FROM pay_payroll_actions appa
, pay_assignment_actions act
, per_all_assignments_f as1
, pay_payroll_actions ppa
WHERE ppa.payroll_action_id = p_payroll_action_id
AND appa.effective_date BETWEEN csr_v_canonical_start_date
AND csr_v_canonical_end_date
AND appa.action_type IN ('R', 'Q')
-- Payroll Run or Quickpay Run
AND act.payroll_action_id = appa.payroll_action_id
AND act.source_action_id IS NULL -- Master Action
AND as1.assignment_id = act.assignment_id
AND as1.business_group_id = g_business_group_id
AND act.action_status = 'C' -- Completed
AND act.tax_unit_id = csr_v_legal_employer_id
AND appa.effective_date BETWEEN as1.effective_start_date
AND as1.effective_end_date
AND ppa.effective_date BETWEEN as1.effective_start_date
AND as1.effective_end_date
ORDER BY as1.person_id, act.assignment_id;
'SELECT DISTINCT person_id
FROM per_people_f ppf
,pay_payroll_actions ppa
WHERE ppa.payroll_action_id = :payroll_action_id
AND ppa.business_group_id = ppf.business_group_id
ORDER BY ppf.person_id';
'select 1 from dual where to_char(:payroll_action_id) = dummy';
/* SELECT as1.person_id person_id, act.assignment_id assignment_id
, act.assignment_action_id run_action_id
, act1.assignment_action_id prepaid_action_id
FROM pay_payroll_actions ppa
, pay_payroll_actions appa
, pay_payroll_actions appa2
, pay_assignment_actions act
, pay_assignment_actions act1
, pay_action_interlocks pai
, per_all_assignments_f as1
WHERE ppa.payroll_action_id = p_payroll_action_id
AND appa.effective_date BETWEEN l_canonical_start_date
AND l_canonical_end_date
AND as1.person_id BETWEEN p_start_person AND p_end_person
AND appa.action_type IN ('R', 'Q')
-- Payroll Run or Quickpay Run
AND act.payroll_action_id = appa.payroll_action_id
AND act.source_action_id IS NULL -- Master Action
AND as1.assignment_id = act.assignment_id
AND as1.business_group_id = g_business_group_id
AND ppa.effective_date BETWEEN as1.effective_start_date
AND as1.effective_end_date
AND act.action_status = 'C' -- Completed
AND act.assignment_action_id = pai.locked_action_id
AND act1.assignment_action_id = pai.locking_action_id
AND act1.action_status = 'C' -- Completed
AND act1.payroll_action_id = appa2.payroll_action_id
AND appa2.action_type IN ('P', 'U')
AND appa2.effective_date BETWEEN l_canonical_start_date
AND l_canonical_end_date
-- Prepayments or Quickpay Prepayments
AND act.tax_unit_id = act1.tax_unit_id
AND act.tax_unit_id = NVL (p_legal_employer_id, act.tax_unit_id)
ORDER BY as1.person_id, act.assignment_id;
SELECT as1.person_id person_id, act.assignment_id assignment_id
, act.assignment_action_id run_action_id
FROM pay_payroll_actions appa
, pay_assignment_actions act
, per_all_assignments_f as1
, pay_payroll_actions ppa
WHERE ppa.payroll_action_id = p_payroll_action_id
AND appa.effective_date BETWEEN l_canonical_start_date
AND l_canonical_end_date
AND as1.person_id BETWEEN p_start_person AND p_end_person
AND appa.action_type IN ('R', 'Q')
-- Payroll Run or Quickpay Run
AND act.payroll_action_id = appa.payroll_action_id
AND act.source_action_id IS NULL -- Master Action
AND as1.assignment_id = act.assignment_id
AND as1.business_group_id = g_business_group_id
AND act.action_status = 'C' -- Completed
AND act.tax_unit_id = NVL (p_legal_employer_id, act.tax_unit_id)
AND appa.effective_date BETWEEN as1.effective_start_date
AND as1.effective_end_date
AND ppa.effective_date BETWEEN as1.effective_start_date
AND as1.effective_end_date
ORDER BY as1.person_id, act.assignment_id;
SELECT ue.creator_id
FROM ff_user_entities ue, ff_database_items di
WHERE di.user_name = csr_v_balance_name
AND ue.user_entity_id = di.user_entity_id
AND ue.legislation_code = 'SE'
AND ue.business_group_id IS NULL
AND ue.creator_type = 'B';
SELECT pay_assignment_actions_s.NEXTVAL
INTO l_actid
FROM DUAL;
SELECT u.creator_id
FROM ff_user_entities u, ff_database_items d
WHERE d.user_name = p_user_name
AND u.user_entity_id = d.user_entity_id
AND (u.legislation_code = 'SE')
AND (u.business_group_id IS NULL)
AND u.creator_type = 'B';
SELECT u.creator_id
FROM ff_user_entities u, ff_database_items d
WHERE d.user_name = p_user_name
AND u.user_entity_id = d.user_entity_id
AND (u.legislation_code = 'SE')
AND (u.business_group_id IS NULL)
AND u.creator_type = 'B';
SELECT ue.creator_id
FROM ff_user_entities ue, ff_database_items di
WHERE di.user_name = csr_v_balance_name
AND ue.user_entity_id = di.user_entity_id
AND ue.legislation_code = 'SE'
AND ue.business_group_id IS NULL
AND ue.creator_type = 'B';
SELECT pap.last_name, pap.pre_name_adjunct, pap.first_name
, pap.national_identifier, pap.person_id, pac.assignment_id
, paa.assignment_number, paa.employee_category
FROM pay_assignment_actions pac
, per_all_assignments_f paa
, per_all_people_f pap
WHERE pac.assignment_action_id = p_asg_act_id
AND paa.assignment_id = pac.assignment_id
AND paa.person_id = pap.person_id
AND pap.per_information_category = 'SE'
AND p_effective_date BETWEEN pap.effective_start_date
AND pap.effective_end_date
AND p_effective_date BETWEEN paa.effective_start_date
AND paa.effective_end_date;
SELECT scl.segment2, scl.segment8
FROM per_all_assignments_f paa
, hr_soft_coding_keyflex scl
, pay_assignment_actions pasa
WHERE pasa.assignment_action_id = p_assignment_action_id
AND pasa.assignment_id = paa.assignment_id
AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
AND paa.primary_flag = 'Y'
AND p_effective_date BETWEEN paa.effective_start_date
AND paa.effective_end_date;
SELECT hoi3.organization_id legal_id
FROM hr_all_organization_units o1
, hr_organization_information hoi1
, hr_organization_information hoi2
, hr_organization_information hoi3
WHERE o1.business_group_id = g_business_group_id
AND hoi1.organization_id = o1.organization_id
AND hoi1.organization_id = csr_v_organization_id
AND hoi1.org_information1 = 'SE_LOCAL_UNIT'
AND hoi1.org_information_context = 'CLASS'
AND o1.organization_id = hoi2.org_information1
AND hoi2.org_information_context = 'SE_LOCAL_UNITS'
AND hoi2.organization_id = hoi3.organization_id
AND hoi3.org_information_context = 'CLASS'
AND hoi3.org_information1 = 'HR_LEGAL_EMPLOYER';
SELECT o1.NAME, hoi2.org_information1
FROM hr_organization_units o1
, hr_organization_information hoi1
, hr_organization_information hoi2
WHERE o1.business_group_id = g_business_group_id
AND hoi1.organization_id = o1.organization_id
AND hoi1.organization_id = csr_v_local_unit_id
AND hoi1.org_information1 = 'SE_LOCAL_UNIT'
AND hoi1.org_information_context = 'CLASS'
AND o1.organization_id = hoi2.organization_id
AND hoi2.org_information_context = 'SE_LOCAL_UNIT_DETAILS';
SELECT 1
INTO l_flag
FROM pay_action_information
WHERE action_information_category = 'EMEA REPORT DETAILS'
AND action_information1 = 'PYSEHPDA'
AND action_context_id = p_assignment_action_id;
SELECT action_information3, action_information4
, action_information5
FROM pay_action_information
WHERE action_context_type = 'PA'
AND action_context_id = csr_v_pa_id
AND action_information_category = 'EMEA REPORT INFORMATION'
AND action_information1 = 'PYSEHPDA'
AND action_information2 = 'LE';
SELECT TO_CHAR
(fnd_date.canonical_to_date (action_information5)
, 'YYYYMMDD'
) period_from
, TO_CHAR
(fnd_date.canonical_to_date (action_information6)
, 'YYYYMMDD'
) period_to
FROM pay_action_information
WHERE action_context_type = 'PA'
AND action_context_id = csr_v_pa_id
AND action_information_category = 'EMEA REPORT DETAILS'
AND action_information1 = 'PYSEHPDA';
SELECT *
FROM pay_action_information
WHERE action_context_type = 'AAP'
AND action_information_category = 'EMEA REPORT INFORMATION'
AND action_information1 = 'PYSEHPDA'
AND action_information3 = csr_v_pa_id
AND action_information2 = 'PER'
AND action_information15 = csr_v_le_id
ORDER BY action_information30;
SELECT payroll_action_id
INTO l_payroll_action_id
FROM pay_payroll_actions ppa
, fnd_conc_req_summary_v fcrs
, fnd_conc_req_summary_v fcrs1
WHERE fcrs.request_id = fnd_global.conc_request_id
AND fcrs.priority_request_id = fcrs1.priority_request_id
AND ppa.request_id BETWEEN fcrs1.request_id AND fcrs.request_id
AND ppa.request_id = fcrs1.request_id;