APPS.PQP_GB_PSI_FUNCTIONS dependencies on PAY_ELEMENT_ENTRIES_F

Line 400: from pay_element_entries_f pee ,pay_element_links_f pel

396: IS
397: select 'Y' from dual
398: where
399: (select pee.element_type_id
400: from pay_element_entries_f pee ,pay_element_links_f pel
401: where pee.element_link_id = pel.element_link_id
402: and pel.business_group_id = p_business_group_id
403: and pee.assignment_id = p_assignment_id
404: and pee.element_type_id = p_element_type_id

Line 849: FROM pay_element_entries_f

845: -- Information type is passed as parameter
846: -- =============================================================================
847: CURSOR csr_get_element_type_id(c_element_entry_id IN NUMBER) IS
848: SELECT element_type_id
849: FROM pay_element_entries_f
850: WHERE element_entry_id = c_element_entry_id
851: AND rownum=1;
852:
853:

Line 972: FROM pay_element_entries_f

968: SELECT *
969: -- element_entry_id, effective_start_date, effective_end_date, creator_type,
970: -- ,entry_type, creator_id, source_id, source_asg_action_id, source_start_date,
971: -- ,source_end_date, element_type_id
972: FROM pay_element_entries_f
973: WHERE source_asg_action_id = p_source_asg_action_id
974: AND source_id = p_source_id
975: AND assignment_id = p_assignment_id
976: AND effective_end_date <= p_effective_date;

Line 1026: INDEX (EE PAY_ELEMENT_ENTRIES_F_N50)

1022: INDEX (BACT PAY_PAYROLL_ACTIONS_PK)
1023: INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N51 )
1024: INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N1 )
1025: INDEX (PACT PAY_PAYROLL_ACTIONS_PK)
1026: INDEX (EE PAY_ELEMENT_ENTRIES_F_N50)
1027: INDEX (RR PAY_RUN_RESULTS_N51)
1028: INDEX (RRV PAY_RUN_RESULT_VALUES_N50)
1029: */
1030: RRV.input_value_id,

Line 1045: pay_element_entries_f EE,

1041: from pay_assignment_actions BAL_ASSACT,
1042: pay_payroll_actions BACT,
1043: pay_assignment_actions ASSACT,
1044: pay_payroll_actions PACT,
1045: pay_element_entries_f EE,
1046: pay_run_results RR,
1047: pay_run_result_values RRV
1048: where BAL_ASSACT.assignment_action_id = p_assignment_action_id
1049: and BACT.payroll_action_id = BAL_ASSACT.payroll_action_id