[Home] [Help]
4850: cursor csr_valid_eff_date(p_position_id number,
4851: p_validation_start_date date,
4852: p_validation_end_date date) is
4853: select p_validation_start_date start_date
4854: from dual
4855: union
4856: select effective_start_date start_date
4857: from hr_all_positions_f
4858: where effective_start_date between p_validation_start_date
7232: l_exists := NULL;
7233: begin
7234: select '1'
7235: into l_exists
7236: from sys.dual
7237: where exists(SELECT NULL
7238: from PER_BUDGET_ELEMENTS BE
7239: where BE.POSITION_ID = p_position_id);
7240: exception when no_data_found then
7250: end if;
7251: begin
7252: select '1'
7253: into l_exists
7254: from sys.dual
7255: where exists(SELECT NULL
7256: from PER_ALL_VACANCIES VAC
7257: where VAC.POSITION_ID = p_position_id);
7258: exception when no_data_found then
7288: if l_pos_structure_element_id is null then
7289: begin
7290: select '1'
7291: into l_exists
7292: from sys.dual
7293: where exists(SELECT NULL
7294: FROM PER_POS_STRUCTURE_ELEMENTS PSE
7295: WHERE PSE.PARENT_POSITION_ID = p_position_id
7296: OR PSE.SUBORDINATE_POSITION_ID = p_position_id) ;
7311: end if;
7312: begin
7313: select '1'
7314: into l_exists
7315: from sys.dual
7316: where exists(SELECT NULL
7317: FROM PER_VALID_GRADES VG1
7318: WHERE business_group_id + 0 = p_business_group_id
7319: AND VG1.POSITION_ID = p_position_id);
7333: end if;
7334: begin
7335: select '1'
7336: into l_exists
7337: from sys.dual
7338: where exists(select null
7339: from per_job_requirements jre1
7340: where jre1.position_id = p_position_id);
7341: exception when no_data_found then
7351: end if;
7352: begin
7353: select '1'
7354: into l_exists
7355: from sys.dual
7356: where exists(select null
7357: from per_job_evaluations jev1
7358: where jev1.position_id = p_position_id);
7359: exception when no_data_found then
7370: end if;
7371: begin
7372: select '1'
7373: into l_exists
7374: from sys.dual
7375: where exists(select null
7376: from hr_all_positions_f
7377: where successor_position_id = p_position_id);
7378: exception when no_data_found then
7391: end if;
7392: begin
7393: select '1'
7394: into l_exists
7395: from sys.dual
7396: where exists(select null
7397: from hr_all_positions_f
7398: where supervisor_position_id = p_position_id);
7399: exception when no_data_found then
7413: /*
7414: begin
7415: select '1'
7416: into l_exists
7417: from sys.dual
7418: where exists(select null
7419: from per_position_extra_info
7420: where position_id = p_position_id);
7421: exception when no_data_found then
7433:
7434: begin
7435: select '1'
7436: into l_exists
7437: from sys.dual
7438: where exists(select null
7439: from per_mm_positions
7440: where new_position_id = p_position_id);
7441: exception when no_data_found then
7455: --
7456: begin
7457: select '1'
7458: into l_exists
7459: from sys.dual
7460: where exists(select null
7461: from pqh_position_transactions
7462: where position_id = p_position_id);
7463: exception when no_data_found then
7476: --
7477: begin
7478: select '1'
7479: into l_exists
7480: from sys.dual
7481: where exists(select null
7482: from pqh_attribute_ranges
7483: where position_id = p_position_id);
7484: exception when no_data_found then
7497: --
7498: begin
7499: select '1'
7500: into l_exists
7501: from sys.dual
7502: where exists(select null
7503: from pqh_budgets
7504: where position_id = p_position_id);
7505: exception when no_data_found then
7518: --
7519: begin
7520: select '1'
7521: into l_exists
7522: from sys.dual
7523: where exists(select null
7524: from pqh_worksheet_details
7525: where position_id = p_position_id);
7526: exception when no_data_found then
7538: --
7539: -- if p_po_ins = 'Y' then
7540: begin
7541: l_sql_text := 'select null '
7542: ||' from sys.dual '
7543: ||' where exists( select null '
7544: ||' from po_system_parameters '
7545: ||' where security_position_structure_id = '
7546: ||to_char(p_position_id)
8059: l_proc varchar2(72) := g_package||'chk_ref_int_del';
8060: --
8061: cursor csr_assgt is
8062: select null
8063: from sys.dual
8064: where exists(select null
8065: from per_all_assignments_f
8066: where position_id = p_position_id
8067: and (p_datetrack_mode = 'ZAP'
8069: and effective_start_date >= p_validation_start_date)));
8070:
8071: cursor csr_element_links is
8072: select null
8073: from sys.dual
8074: where exists(select null
8075: from pay_element_links_f
8076: where position_id = p_position_id
8077: and (p_datetrack_mode = 'ZAP'
8079: and effective_start_date >= p_validation_start_date)));
8080:
8081: cursor csr_budget_details is
8082: select null
8083: from sys.dual
8084: where exists(select null
8085: from pqh_budget_details
8086: where position_id = p_position_id
8087: and p_datetrack_mode = 'ZAP');