APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 576: pay_element_entry_values_f peev

572: pay_element_classifications pec,
573: pay_element_types_f pet,
574: pay_input_values_f piv,
575: pay_element_entries_f pee,
576: pay_element_entry_values_f peev
577: where paa.person_id between stperson AND endperson
578: and (fnd_date.canonical_to_date(l_benefit_end_date)
579: between paa.effective_start_date AND paa.effective_end_date
580: or

Line 644: pay_element_entry_values_f peev

640: pay_element_classifications pec,
641: pay_element_types_f pet,
642: pay_input_values_f piv,
643: pay_element_entries_f pee,
644: pay_element_entry_values_f peev
645: where paa.person_id between stperson AND endperson
646: and (fnd_date.canonical_to_date(l_benefit_end_date)
647: between paa.effective_start_date AND paa.effective_end_date
648: or

Line 701: pay_element_entry_values_f peev

697: pay_element_classifications pec,
698: pay_element_types_f pet,
699: pay_input_values_f piv,
700: pay_element_entries_f pee,
701: pay_element_entry_values_f peev
702: where paa.person_id between stperson AND endperson
703: and (fnd_date.canonical_to_date(l_benefit_end_date)
704: between paa.effective_start_date AND paa.effective_end_date
705: or

Line 1052: pay_element_entry_values_f peev,

1048: paa.assignment_id, UPPER('GB_'|| pec.classification_name) classification_name
1049: FROM pay_element_types_f pet,
1050: pay_element_classifications pec,
1051: pay_input_values_f piv,
1052: pay_element_entry_values_f peev,
1053: pay_element_entries_f pee,
1054: per_assignments_f paa,
1055: pay_assignment_actions paac
1056: WHERE pet.classification_id = pec.classification_id AND

Line 1070: CURSOR csr_element_entry_values(v_element_entry_id pay_element_entry_values_f.element_entry_id%TYPE,

1066: peev.screen_entry_value BETWEEN v_benefit_start_date AND v_benefit_end_date
1067: ORDER BY pet.element_type_id, peev.element_entry_id, peev.effective_start_date;
1068:
1069:
1070: CURSOR csr_element_entry_values(v_element_entry_id pay_element_entry_values_f.element_entry_id%TYPE,
1071: v_element_type_id pay_element_types_f.element_type_id%TYPE,
1072: v_effective_start_date DATE)
1073: IS
1074: SELECT peev.screen_entry_value, UPPER(TRANSLATE(piv.NAME, ' ', '_') ) NAME

Line 1075: FROM pay_input_values_f piv, pay_element_entry_values_f peev

1071: v_element_type_id pay_element_types_f.element_type_id%TYPE,
1072: v_effective_start_date DATE)
1073: IS
1074: SELECT peev.screen_entry_value, UPPER(TRANSLATE(piv.NAME, ' ', '_') ) NAME
1075: FROM pay_input_values_f piv, pay_element_entry_values_f peev
1076: WHERE piv.input_value_id = peev.input_value_id AND
1077: piv.element_type_id = v_element_type_id AND
1078: peev.element_entry_id = v_element_entry_id AND
1079: peev.effective_start_date = v_effective_start_date;

Line 1100: Cursor csr_non_iv_action_info_items(v_element_entry_id pay_element_entry_values_f.element_entry_id%TYPE,

1096: descriptive_flexfield_name = 'Action Information DF' AND
1097: descriptive_flex_context_code = v_element_name AND
1098: (enabled_flag IS NULL OR enabled_flag = 'Y');
1099:
1100: Cursor csr_non_iv_action_info_items(v_element_entry_id pay_element_entry_values_f.element_entry_id%TYPE,
1101: v_element_type_id pay_element_types_f.element_type_id%TYPE,
1102: v_effective_start_date DATE,
1103: v_element_name VARCHAR2,
1104: v_classification_name VARCHAR2)

Line 1124: pay_element_entry_values_f peev

1120: flex_ele.end_user_column_name = flex_act.end_user_column_name ) AND
1121: not Exists (
1122: SELECT /*+ no_unnest */ 1
1123: FROM pay_input_values_f piv,
1124: pay_element_entry_values_f peev
1125: WHERE piv.input_value_id = peev.input_value_id AND
1126: piv.element_type_id = v_element_type_id AND
1127: peev.element_entry_id = v_element_entry_id AND
1128: peev.effective_start_date = v_effective_start_date AND