APPS.PAY_FI_ARCHIVE_PSTA dependencies on PAY_ELEMENT_ENTRIES_F

Line 530: pay_element_entries_f ee,

526: per_all_people_f per,
527: pay_element_links_f el,
528: pay_element_types_f et,
529: pay_input_values_f iv1,
530: pay_element_entries_f ee,
531: pay_element_entry_values_f eev1
532: where asg1.assignment_id = p_assignment_id
533: and p_value_date between asg1.effective_start_date and asg1.effective_end_date
534: and p_value_date between asg2.effective_start_date and asg2.effective_end_date

Line 1096: pay_element_entries_f ee,

1092: per_all_people_f per,
1093: pay_element_links_f el,
1094: pay_element_types_f et,
1095: pay_input_values_f iv1,
1096: pay_element_entries_f ee,
1097: pay_element_entry_values_f eev1
1098: where asg1.assignment_id = p_assignment_id
1099: and p_value_date between asg1.effective_start_date and asg1.effective_end_date
1100: and p_value_date between asg2.effective_start_date and asg2.effective_end_date

Line 1129: pay_element_entries_f ee,

1125: per_all_people_f per,
1126: pay_element_links_f el,
1127: pay_element_types_f et,
1128: pay_input_values_f iv1,
1129: pay_element_entries_f ee,
1130: pay_element_entry_values_f eev1
1131: where asg1.assignment_id = p_assignment_id
1132: and p_value_date between asg1.effective_start_date and asg1.effective_end_date
1133: and p_value_date between asg2.effective_start_date and asg2.effective_end_date

Line 1156: from pay_element_classifications pec, pay_element_types_f pat, pay_element_entries_f pet

1152: cursor csr_get_benefit_type (
1153: p_assignment_id per_all_assignments_f.assignment_id%type
1154: ) is
1155: select pat.element_type_id, pat.element_name, pat.element_information1 benefit_type_code
1156: from pay_element_classifications pec, pay_element_types_f pat, pay_element_entries_f pet
1157: where pec.classification_name = 'Benefits in Kind'
1158: and pec.legislation_code = 'FI'
1159: and (pat.legislation_code = 'FI' or pat.business_group_id = g_business_group_id)
1160: and pec.classification_id = pat.classification_id