APPS.PQP_GB_PSI_FUNCTIONS dependencies on PAY_ELEMENT_ENTRIES_F

Line 246: From pay_element_entries_f

242: --Bug 7611963: Cusor to fetch element end date.
243: Cursor csr_get_ele_end_date(p_element_entry_id IN NUMBER)
244: Is
245: Select max(effective_end_date)
246: From pay_element_entries_f
247: Where element_entry_id = p_element_entry_id;
248:
249: g_retro_event_date_reported BOOLEAN := TRUE;
250:

Line 407: from pay_element_entries_f pee ,pay_element_links_f pel

403: IS
404: select 'Y' from dual
405: where
406: (select pee.element_type_id
407: from pay_element_entries_f pee ,pay_element_links_f pel
408: where pee.element_link_id = pel.element_link_id
409: and pel.business_group_id = p_business_group_id
410: and pee.assignment_id = p_assignment_id
411: and pee.element_type_id = p_element_type_id

Line 856: FROM pay_element_entries_f

852: -- Information type is passed as parameter
853: -- =============================================================================
854: CURSOR csr_get_element_type_id(c_element_entry_id IN NUMBER) IS
855: SELECT element_type_id
856: FROM pay_element_entries_f
857: WHERE element_entry_id = c_element_entry_id
858: AND rownum=1;
859:
860:

Line 983: FROM pay_element_entries_f

979: SELECT *
980: -- element_entry_id, effective_start_date, effective_end_date, creator_type,
981: -- ,entry_type, creator_id, source_id, source_asg_action_id, source_start_date,
982: -- ,source_end_date, element_type_id
983: FROM pay_element_entries_f
984: WHERE source_asg_action_id = p_source_asg_action_id
985: AND (source_id = p_source_id OR source_id = p_ele_entry_id)
986: AND assignment_id = p_assignment_id
987: AND effective_end_date <= p_effective_date;

Line 1002: SELECT * FROM pay_element_entries_f

998: ,p_effective_start_date DATE
999: ,p_ele_entry_id NUMBER
1000: )
1001: IS
1002: SELECT * FROM pay_element_entries_f
1003: WHERE source_id = p_ele_entry_id
1004: AND assignment_id = p_assignment_id
1005: AND effective_end_date <= p_effective_end_date
1006: AND effective_start_date >= p_effective_start_date;

Line 1055: INDEX (EE PAY_ELEMENT_ENTRIES_F_N50)

1051: INDEX (BACT PAY_PAYROLL_ACTIONS_PK)
1052: INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N51 )
1053: INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N1 )
1054: INDEX (PACT PAY_PAYROLL_ACTIONS_PK)
1055: INDEX (EE PAY_ELEMENT_ENTRIES_F_N50)
1056: INDEX (RR PAY_RUN_RESULTS_N51)
1057: INDEX (RRV PAY_RUN_RESULT_VALUES_N50)
1058: */
1059: RRV.input_value_id,

Line 1074: pay_element_entries_f EE,

1070: from pay_assignment_actions BAL_ASSACT,
1071: pay_payroll_actions BACT,
1072: pay_assignment_actions ASSACT,
1073: pay_payroll_actions PACT,
1074: pay_element_entries_f EE,
1075: pay_run_results RR,
1076: pay_run_result_values RRV
1077: where BAL_ASSACT.assignment_action_id = p_assignment_action_id
1078: and BACT.payroll_action_id = BAL_ASSACT.payroll_action_id