APPS.PAY_USER_COLUMN_INSTA_MATRIX dependencies on HR_PUMP_BATCH_LINE_USER_KEYS

Line 664: from hr_pump_batch_line_user_keys

660: and puc.user_column_name = c_user_column_name
661: and puc.user_table_id = put.user_table_id
662: and put.user_table_name = c_user_table_name
663: and not exists(select null
664: from hr_pump_batch_line_user_keys
665: where user_key_value = c_user_key_value
666: and unique_key_id = puc.user_column_id);
667:
668:

Line 673: from hr_pump_batch_line_user_keys

669:
670: cursor csr_check_user_key_exists(c_unique_key_id number)
671: is
672: select user_key_id
673: from hr_pump_batch_line_user_keys
674: where user_key_value like 'PAY_USER_COLUMN%'
675: and unique_key_id = c_unique_key_id;
676:
677:

Line 691: delete from hr_pump_batch_line_user_keys where user_key_id = l_user_key_id;

687: open csr_check_user_key_exists(l_user_column_id);
688: fetch csr_check_user_key_exists into l_user_key_id;
689:
690: if csr_check_user_key_exists%found then
691: delete from hr_pump_batch_line_user_keys where user_key_id = l_user_key_id;
692: end if;
693:
694: close csr_check_user_key_exists;
695: hr_pump_utils.add_user_key

Line 742: from hr_pump_batch_line_user_keys

738: and pur.row_low_range_or_name = c_user_row_name
739: and pur.user_table_id = put.user_table_id
740: and put.user_table_name = c_user_table_name
741: and not exists(select null
742: from hr_pump_batch_line_user_keys
743: where user_key_value = c_user_key_value
744: and unique_key_id = pur.user_row_id);
745:
746:

Line 750: from hr_pump_batch_line_user_keys

746:
747: cursor csr_check_user_key_exists(c_unique_key_id number)
748: is
749: select user_key_id
750: from hr_pump_batch_line_user_keys
751: where user_key_value like 'PAY_USER_ROW%'
752: and unique_key_id = c_unique_key_id;
753:
754:

Line 773: delete from hr_pump_batch_line_user_keys where user_key_id = l_user_key_id;

769: open csr_check_user_key_exists(l_user_row_id);
770: fetch csr_check_user_key_exists into l_user_key_id;
771:
772: if csr_check_user_key_exists%found then
773: delete from hr_pump_batch_line_user_keys where user_key_id = l_user_key_id;
774: end if;
775:
776: close csr_check_user_key_exists;
777: hr_pump_utils.add_user_key

Line 819: from hr_pump_batch_line_user_keys

815:
816: cursor csr_check_user_key_exists(c_unique_key_id number)
817: is
818: select user_key_id
819: from hr_pump_batch_line_user_keys
820: where user_key_value like 'PAY_USER_TABLE%'
821: and unique_key_id = c_unique_key_id;
822: begin
823:

Line 837: delete from hr_pump_batch_line_user_keys where user_key_id = l_user_key_id;

833: open csr_check_user_key_exists(l_user_table_id);
834: fetch csr_check_user_key_exists into l_user_key_id;
835:
836: if csr_check_user_key_exists%found then
837: delete from hr_pump_batch_line_user_keys where user_key_id = l_user_key_id;
838: end if;
839:
840: close csr_check_user_key_exists;
841: hr_pump_utils.add_user_key