[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT NVL(PTP.start_date, END_OF_TIME)
FROM per_time_periods PTP
,per_assignments_f ASS
WHERE ASS.assignment_id = p_assignment_id
AND p_upload_date BETWEEN ASS.effective_start_date AND ASS.effective_end_date
AND PTP.payroll_id = ASS.payroll_id
AND p_upload_date BETWEEN PTP.start_date AND PTP.end_date;
SELECT NVL(GREATEST(MIN(ASS.effective_start_date), p_expiry_date),END_OF_TIME)
FROM per_assignments_f ASS
WHERE ASS.assignment_id = p_assignment_id
AND ASS.effective_start_date <= p_upload_date
AND ASS.effective_end_date >= p_expiry_date;
SELECT balance_dimension_id
FROM pay_balance_dimensions
WHERE dimension_name = p_dimension_name
AND legislation_code = 'IN'
AND dimension_name NOT IN ( '_ASG_RUN'
, '_ASG_ORG_RUN'
, '_ASG_STATE_RUN'
, '_PAYMENTS'
, '_ASG_LE_RUN'
, '_ASG_COMP_RUN'
, '_ASG_LE_COMP_RUN'
, '_ASG_SRC_RUN'
,'_ASG_COMP_LTD'
,'_ASG_LE_FY_PMTH'
,'_ASG_PMTH'
,'_ASG_P10MTH'
);
SELECT BT.balance_type_id
FROM pay_balance_types BT
WHERE BT.balance_type_id = p_balance_type_id
and ((p_source_id is null) or
(p_source_id is not null and p_source_id = p_bal_adj_source_id))
and ((p_tax_unit_id is null) or
(p_tax_unit_id is not null and p_tax_unit_id = p_bal_adj_tax_unit_id))
and ((p_jurisdiction_code is null) or
(p_jurisdiction_code is not null and p_jurisdiction_code = p_bal_adj_jurisdiction_code))
and ((p_source_text is null) or
(p_source_text is not null and p_source_text = p_bal_adj_source_text))
and ((p_source_text2 is null) or
(p_source_text2 is not null and p_source_text2 = p_bal_adj_source_text2))
AND 1 = 1;
select pbbl.source_id
,pbbl.original_entry_id
,pbbl.tax_unit_id
,pbbl.jurisdiction_code
,pbbl.source_text
,pbbl.source_text2
from pay_balance_batch_lines pbbl
where pbbl.batch_line_id = p_batch_line_id;
SELECT source_id
,original_entry_id
,tax_unit_id
,jurisdiction_code
,source_text
,source_text2
FROM pay_temp_balance_adjustments
WHERE batch_line_id = p_test_batch_line_id;