APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on PAY_ELEMENT_ENTRIES_F

Line 1992: FROM pay_element_entries_f pee, pay_element_links_f pel

1988: CURSOR csr_get_ele_ent_details(c_element_type_id NUMBER)
1989: IS
1990: SELECT pee.element_entry_id, pee.effective_start_date
1991: ,pee.effective_end_date, pel.element_type_id
1992: FROM pay_element_entries_f pee, pay_element_links_f pel
1993: WHERE pee.assignment_id = p_assignment_id
1994: AND pee.entry_type = 'E'
1995: AND pee.element_link_id = pel.element_link_id
1996: AND p_effective_date BETWEEN pee.effective_start_date

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

2139:
2140: i := 1;
2141: l_table_name(i) := 'PER_ALL_ASSIGNMENTS_F';
2142: i := i + 1;
2143: l_table_name(i) := 'PAY_ELEMENT_ENTRIES_F';
2144: i := i + 1;
2145: l_table_name(i) := 'PAY_ELEMENT_ENTRY_VALUES_F';
2146: i := i + 1;
2147: l_table_name(i) := 'PER_ALL_PEOPLE_F';

Line 3286: FROM pay_element_entries_f pee, pay_element_links_f pel

3282: )
3283: IS
3284: SELECT pee.element_entry_id, pee.effective_start_date
3285: ,pee.effective_end_date, pel.element_type_id
3286: FROM pay_element_entries_f pee, pay_element_links_f pel
3287: WHERE pee.assignment_id = p_assignment_id
3288: AND pee.entry_type = 'E'
3289: AND pee.element_link_id = pel.element_link_id
3290: AND (

Line 3316: FROM pay_element_entries_f pee, pay_element_links_f pel

3312: )
3313: IS
3314: SELECT pee.element_entry_id, pee.effective_start_date
3315: ,pee.effective_end_date
3316: FROM pay_element_entries_f pee, pay_element_links_f pel
3317: WHERE pee.assignment_id = p_assignment_id
3318: AND pee.entry_type = 'E'
3319: AND pee.element_link_id = pel.element_link_id
3320: AND (

Line 5039: FROM pay_element_entries_f

5035:
5036: CURSOR csr_get_opt_in_info_next_day
5037: IS
5038: SELECT element_type_id
5039: FROM pay_element_entries_f
5040: WHERE assignment_id = p_assignment_id
5041: AND element_type_id = p_element_type_id
5042: AND effective_start_date = p_pension_change_date + 1;
5043:

Line 5047: FROM pay_element_entries_f

5043:
5044: CURSOR csr_get_opt_out_info_prev_day
5045: IS
5046: SELECT element_type_id
5047: FROM pay_element_entries_f
5048: WHERE assignment_id = p_assignment_id
5049: AND element_type_id = p_element_type_id
5050: AND effective_end_date = p_pension_change_date - 1;
5051:

Line 5147: FROM pay_element_entries_f pee, pay_element_links_f pel

5143: CURSOR csr_get_ele_ent_info(c_element_entry_id NUMBER)
5144: IS
5145: SELECT pel.element_type_id, pee.effective_start_date
5146: ,pee.effective_end_date, pee.element_entry_id
5147: FROM pay_element_entries_f pee, pay_element_links_f pel
5148: WHERE pee.element_entry_id = c_element_entry_id
5149: AND g_effective_date BETWEEN pee.effective_start_date
5150: AND pee.effective_end_date
5151: AND pel.element_link_id = pee.element_link_id

Line 5208: FROM pay_element_entries_f

5204: --start of employment_category and pension element start date
5205: CURSOR csr_get_ele_type (asg_start_date DATE,ele_start_date DATE)
5206: IS
5207: SELECT element_type_id
5208: FROM pay_element_entries_f
5209: WHERE assignment_id = p_assignment_id
5210: AND effective_start_date BETWEEN asg_start_date
5211: AND (ele_start_date-1)
5212: ORDER BY effective_start_date;

Line 5255: IF p_table_name = 'PAY_ELEMENT_ENTRIES_F'

5251: END IF;
5252:
5253: l_return := 'N';
5254:
5255: IF p_table_name = 'PAY_ELEMENT_ENTRIES_F'
5256: THEN
5257: IF g_debug
5258: THEN
5259: l_proc_step := 20;

Line 5883: FROM pay_element_entries_f

5879: --Cursor to fetch elements attached on asg_category change date
5880: CURSOR cur_get_asg_chg_dt_ele(c_asg_cate_chng_date DATE)
5881: IS
5882: SELECT element_type_id, element_entry_id
5883: FROM pay_element_entries_f
5884: WHERE assignment_id = p_assignment_id
5885: AND effective_start_date = c_asg_cate_chng_date;
5886:
5887: --Cursor to check if the event on Element Entries is an Insert or Update

Line 5891: FROM pay_element_entries_f

5887: --Cursor to check if the event on Element Entries is an Insert or Update
5888: CURSOR cur_get_ele_entry_id(c_element_entry_id NUMBER, c_asg_cate_chng_date DATE)
5889: IS
5890: SELECT element_entry_id
5891: FROM pay_element_entries_f
5892: WHERE assignment_id = p_assignment_id
5893: AND element_entry_id = c_element_entry_id
5894: AND effective_end_date = c_asg_cate_chng_date -1;
5895: --For bug 7013325: End