APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on PAY_ELEMENT_ENTRIES_F

Line 1974: FROM pay_element_entries_f pee, pay_element_links_f pel

1970: CURSOR csr_get_ele_ent_details(c_element_type_id NUMBER)
1971: IS
1972: SELECT pee.element_entry_id, pee.effective_start_date
1973: ,pee.effective_end_date, pel.element_type_id
1974: FROM pay_element_entries_f pee, pay_element_links_f pel
1975: WHERE pee.assignment_id = p_assignment_id
1976: AND pee.entry_type = 'E'
1977: AND pee.element_link_id = pel.element_link_id
1978: AND p_effective_date BETWEEN pee.effective_start_date

Line 2125: l_table_name(i) := 'PAY_ELEMENT_ENTRIES_F';

2121:
2122: i := 1;
2123: l_table_name(i) := 'PER_ALL_ASSIGNMENTS_F';
2124: i := i + 1;
2125: l_table_name(i) := 'PAY_ELEMENT_ENTRIES_F';
2126: i := i + 1;
2127: l_table_name(i) := 'PAY_ELEMENT_ENTRY_VALUES_F';
2128: i := i + 1;
2129: l_table_name(i) := 'PER_ALL_PEOPLE_F';

Line 3268: FROM pay_element_entries_f pee, pay_element_links_f pel

3264: )
3265: IS
3266: SELECT pee.element_entry_id, pee.effective_start_date
3267: ,pee.effective_end_date, pel.element_type_id
3268: FROM pay_element_entries_f pee, pay_element_links_f pel
3269: WHERE pee.assignment_id = p_assignment_id
3270: AND pee.entry_type = 'E'
3271: AND pee.element_link_id = pel.element_link_id
3272: AND (

Line 3298: FROM pay_element_entries_f pee, pay_element_links_f pel

3294: )
3295: IS
3296: SELECT pee.element_entry_id, pee.effective_start_date
3297: ,pee.effective_end_date
3298: FROM pay_element_entries_f pee, pay_element_links_f pel
3299: WHERE pee.assignment_id = p_assignment_id
3300: AND pee.entry_type = 'E'
3301: AND pee.element_link_id = pel.element_link_id
3302: AND (

Line 4985: FROM pay_element_entries_f

4981:
4982: CURSOR csr_get_opt_in_info_next_day
4983: IS
4984: SELECT element_type_id
4985: FROM pay_element_entries_f
4986: WHERE assignment_id = p_assignment_id
4987: AND element_type_id = p_element_type_id
4988: AND effective_start_date = p_pension_change_date + 1;
4989:

Line 4993: FROM pay_element_entries_f

4989:
4990: CURSOR csr_get_opt_out_info_prev_day
4991: IS
4992: SELECT element_type_id
4993: FROM pay_element_entries_f
4994: WHERE assignment_id = p_assignment_id
4995: AND element_type_id = p_element_type_id
4996: AND effective_end_date = p_pension_change_date - 1;
4997:

Line 5093: FROM pay_element_entries_f pee, pay_element_links_f pel

5089: CURSOR csr_get_ele_ent_info(c_element_entry_id NUMBER)
5090: IS
5091: SELECT pel.element_type_id, pee.effective_start_date
5092: ,pee.effective_end_date, pee.element_entry_id
5093: FROM pay_element_entries_f pee, pay_element_links_f pel
5094: WHERE pee.element_entry_id = c_element_entry_id
5095: AND g_effective_date BETWEEN pee.effective_start_date
5096: AND pee.effective_end_date
5097: AND pel.element_link_id = pee.element_link_id

Line 5154: FROM pay_element_entries_f

5150: --start of employment_category and pension element start date
5151: CURSOR csr_get_ele_type (asg_start_date DATE,ele_start_date DATE)
5152: IS
5153: SELECT element_type_id
5154: FROM pay_element_entries_f
5155: WHERE assignment_id = p_assignment_id
5156: AND effective_start_date BETWEEN asg_start_date
5157: AND (ele_start_date-1)
5158: ORDER BY effective_start_date;

Line 5201: IF p_table_name = 'PAY_ELEMENT_ENTRIES_F'

5197: END IF;
5198:
5199: l_return := 'N';
5200:
5201: IF p_table_name = 'PAY_ELEMENT_ENTRIES_F'
5202: THEN
5203: IF g_debug
5204: THEN
5205: l_proc_step := 20;

Line 5821: FROM pay_element_entries_f

5817: --Cursor to fetch elements attached on asg_category change date
5818: CURSOR cur_get_asg_chg_dt_ele(c_asg_cate_chng_date DATE)
5819: IS
5820: SELECT element_type_id, element_entry_id
5821: FROM pay_element_entries_f
5822: WHERE assignment_id = p_assignment_id
5823: AND effective_start_date = c_asg_cate_chng_date;
5824:
5825: --Cursor to check if the event on Element Entries is an Insert or Update

Line 5829: FROM pay_element_entries_f

5825: --Cursor to check if the event on Element Entries is an Insert or Update
5826: CURSOR cur_get_ele_entry_id(c_element_entry_id NUMBER, c_asg_cate_chng_date DATE)
5827: IS
5828: SELECT element_entry_id
5829: FROM pay_element_entries_f
5830: WHERE assignment_id = p_assignment_id
5831: AND element_entry_id = c_element_entry_id
5832: AND effective_end_date = c_asg_cate_chng_date -1;
5833: --For bug 7013325: End