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 702: pay_element_entry_values_f peev

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

Line 1053: pay_element_entry_values_f peev,

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

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

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

Line 1076: FROM pay_input_values_f piv, pay_element_entry_values_f peev

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

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

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

Line 1125: pay_element_entry_values_f peev

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