APPS.PAY_NO_ABSENCE dependencies on PAY_INPUT_VALUES_F

Line 95: ,pay_input_values_f iv1

91: ,per_all_assignments_f asg2
92: ,per_all_people_f per
93: ,pay_element_links_f el
94: ,pay_element_types_f et
95: ,pay_input_values_f iv1
96: ,pay_element_entries_f ee
97: ,pay_element_entry_values_f eev1
98: WHERE asg1.assignment_id = l_asg_id
99: AND l_eff_dt BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 125: , pay_input_values_f piv

121: FROM pay_element_types_f pet
122: , pay_element_entries_f pee
123: , pay_run_results prr
124: , pay_run_result_values prrv
125: , pay_input_values_f piv
126: WHERE pet.element_type_id = pee.element_type_id
127: AND pet.element_type_id = prr.element_type_id
128: AND pee.element_entry_id = prr.element_entry_id
129: AND prr.run_result_id = prrv.run_result_id

Line 207: ,pay_input_values_f pivf

203: /* Cursor to get the initial absence start date for sickness */
204: CURSOR csr_get_intial_sick_abs_st_dt(p_abs_attn_id IN VARCHAR2 ) IS
205: SELECT nvl(peef2.effective_start_date,peef1.effective_start_date)
206: FROM pay_element_entry_values_f peevf
207: ,pay_input_values_f pivf
208: ,pay_element_entries_f peef1
209: ,pay_element_entries_f peef2
210: WHERE peevf.screen_entry_value = p_abs_attn_id
211: AND pivf.input_value_id = peevf.input_value_id

Line 6764: ,pay_input_values_f iv1

6760: ,per_all_assignments_f asg2
6761: ,per_all_people_f per
6762: ,pay_element_links_f el
6763: ,pay_element_types_f et
6764: ,pay_input_values_f iv1
6765: ,pay_element_entries_f ee
6766: ,pay_element_entry_values_f eev1
6767: WHERE asg1.assignment_id = p_assignment_id
6768: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 6792: eename pay_input_values_f.name%TYPE );

6788: ORDER BY ee.element_entry_id;
6789: --
6790: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,
6791: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,
6792: eename pay_input_values_f.name%TYPE );
6793: l_rec l_record;
6794: TYPE l_table is table of l_record index by BINARY_INTEGER;
6795: l_tab l_table;
6796:

Line 7058: ,pay_input_values_f iv1

7054: ,per_all_assignments_f asg2
7055: ,per_all_people_f per
7056: ,pay_element_links_f el
7057: ,pay_element_types_f et
7058: ,pay_input_values_f iv1
7059: ,pay_element_entries_f ee
7060: ,pay_element_entry_values_f eev1
7061: WHERE asg1.assignment_id = p_assignment_id
7062: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 7086: eename pay_input_values_f.name%TYPE );

7082: ORDER BY ee.element_entry_id;
7083: --
7084: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,
7085: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,
7086: eename pay_input_values_f.name%TYPE );
7087: l_rec l_record;
7088: TYPE l_table is table of l_record index by BINARY_INTEGER;
7089: l_tab l_table;
7090:

Line 7112: ,pay_input_values_f iv1

7108: SELECT MAX(ee.effective_end_date)
7109: INTO l_max_date
7110: FROM pay_element_types_f et
7111: ,pay_element_links_f el
7112: ,pay_input_values_f iv1
7113: ,pay_element_entries_f ee
7114: ,pay_element_entry_values_f eev1
7115: WHERE et.element_name = 'Sickness Unpaid'
7116: AND et.legislation_code = 'NO'

Line 7224: ,pay_input_values_f iv1

7220: ,per_all_assignments_f asg2
7221: ,per_all_people_f per
7222: ,pay_element_links_f el
7223: ,pay_element_types_f et
7224: ,pay_input_values_f iv1
7225: ,pay_element_entries_f ee
7226: ,pay_element_entry_values_f eev1
7227: WHERE asg1.assignment_id = p_assignment_id
7228: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 7252: eename pay_input_values_f.name%TYPE );

7248: ORDER BY ee.element_entry_id;
7249: --
7250: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,
7251: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,
7252: eename pay_input_values_f.name%TYPE );
7253: l_rec l_record;
7254: TYPE l_table is table of l_record index by BINARY_INTEGER;
7255: l_tab l_table;
7256:

Line 7297: ,pay_input_values_f iv1

7293: SELECT MAX(ee.effective_end_date)
7294: INTO l_max_date
7295: FROM pay_element_types_f et
7296: ,pay_element_links_f el
7297: ,pay_input_values_f iv1
7298: ,pay_element_entries_f ee
7299: ,pay_element_entry_values_f eev1
7300: WHERE et.element_name = 'Sickness Unpaid'
7301: AND et.legislation_code = 'NO'

Line 7519: pay_input_values_f

7515: WHERE element_entry_id = p_element_entry_id;
7516:
7517: CURSOR csr_get_input_value_id(p_element_type_id NUMBER) IS
7518: SELECT input_value_id from
7519: pay_input_values_f
7520: WHERE element_type_id = p_element_type_id
7521: AND NAME = 'CREATOR_ID';
7522:
7523: CURSOR csr_get_screen_value(p_element_entry_id NUMBER

Line 7617: pay_input_values_f

7613: WHERE element_entry_id = p_element_entry_id;
7614:
7615: CURSOR csr_get_input_value_id(p_element_type_id NUMBER) IS
7616: SELECT input_value_id from
7617: pay_input_values_f
7618: WHERE element_type_id = p_element_type_id
7619: AND NAME = 'CREATOR_ID';
7620:
7621: CURSOR csr_get_screen_value(p_element_entry_id NUMBER

Line 7693: pay_input_values_f pivf,

7689: /* Cursor to get the absence category based on the given element entry id*/
7690: CURSOR csr_abs_category (p_element_entry_id number) is
7691: SELECT screen_entry_value
7692: FROM pay_element_entries_f peef,
7693: pay_input_values_f pivf,
7694: pay_element_entry_values_f peevf
7695: WHERE peef.element_entry_id = p_element_entry_id
7696: AND pivf.element_type_id = peef.element_type_id
7697: AND pivf.name = 'Absence Category'

Line 7954: ,pay_input_values_f pivf

7950:
7951: CURSOR csr_get_intial_abs_st_date(p_abs_attn_id IN VARCHAR2 ) IS
7952: SELECT nvl(peef2.effective_start_date,peef1.effective_start_date)
7953: FROM pay_element_entry_values_f peevf
7954: ,pay_input_values_f pivf
7955: ,pay_element_entries_f peef1
7956: ,pay_element_entries_f peef2
7957: WHERE peevf.screen_entry_value = p_abs_attn_id
7958: AND pivf.input_value_id = peevf.input_value_id