APPS.PSB_COPY_DATA_EXTRACT_PVT dependencies on PSB_PAY_ELEMENTS

Line 511: from psb_pay_elements

507: Cursor l_find_element_csr is
508: Select pay_element_id,
509: name,
510: salary_flag
511: from psb_pay_elements
512: where data_extract_id = p_src_data_extract_id;
513:
514: Cursor l_find_target_element_csr is
515: Select pay_element_id

Line 516: from psb_pay_elements

512: where data_extract_id = p_src_data_extract_id;
513:
514: Cursor l_find_target_element_csr is
515: Select pay_element_id
516: from psb_pay_elements
517: where name = l_element_name
518: and data_extract_id = p_data_extract_id;
519:
520: BEGIN

Line 831: from psb_pay_elements

827: where default_rule_id = l_src_default_rule_id;
828:
829: Cursor C_Pay_Element is
830: Select name
831: from psb_pay_elements
832: where data_extract_id = p_src_data_extract_id
833: and pay_element_id = l_src_pay_element_id;
834:
835: Cursor C_Pay_Element_Dest is

Line 837: from psb_pay_elements

833: and pay_element_id = l_src_pay_element_id;
834:
835: Cursor C_Pay_Element_Dest is
836: Select pay_element_id
837: from psb_pay_elements
838: where data_extract_id = p_data_extract_id
839: and name = l_src_pay_element_name;
840: -- Following two cursor modified as part of bug #5407267
841: -- Bug 4179764 .In the following cursor added

Line 851: FROM psb_pay_element_options peo, psb_pay_elements pe

847: AND pay_element_option_id = l_src_pay_option_id;
848:
849: CURSOR C_Pay_Option_Dest IS
850: SELECT pay_element_option_id
851: FROM psb_pay_element_options peo, psb_pay_elements pe
852: WHERE peo.pay_element_id = pe.pay_element_id
853: AND peo.pay_element_id = l_dest_pay_element_id
854: AND peo.name = l_src_pay_option_name
855: AND DECODE(pe.hr_element_type_id, null, -1, DECODE(pe.salary_type,