APPS.PAY_NO_EERR_STATUS_CONTROL dependencies on PAY_ELEMENT_ENTRIES_F

Line 22: element_entry_id pay_element_entries_f.element_entry_id%type,

18: new_value varchar2(2000),
19: change_values varchar2(2000),
20: proration_type varchar2(10),
21: change_mode pay_process_events.change_type%type,--'DATE_PROCESSED' etc
22: element_entry_id pay_element_entries_f.element_entry_id%type,
23: next_ee number ,
24: assignment_id per_all_Assignments_f.assignment_id%type
25: );
26:

Line 716: from pay_element_entries_f peef, pay_element_types_f pet

712: c_eff_date date,
713: c_element_name varchar2
714: ) is
715: select peef.element_entry_id
716: from pay_element_entries_f peef, pay_element_types_f pet
717: where pet.element_name = c_element_name
718: and pet.legislation_code = 'NO'
719: and peef.assignment_id = c_assignment_id
720: and peef.element_type_id = pet.element_type_id

Line 755: from pay_element_entries_f peef, pay_element_types_f pet

751: c_eff_date date,
752: c_element_name varchar2
753: ) is
754: select peef.element_entry_id
755: from pay_element_entries_f peef, pay_element_types_f pet
756: where pet.element_name = c_element_name
757: and pet.legislation_code = 'NO'
758: and peef.assignment_id = c_assignment_id
759: and peef.element_type_id = pet.element_type_id

Line 772: from pay_element_entries_f peef, pay_element_types_f pet

768: p_end_date date,
769: p_element_name varchar2
770: ) is
771: select peef.element_entry_id
772: from pay_element_entries_f peef, pay_element_types_f pet
773: where pet.element_name = p_element_name
774: and pet.legislation_code = 'NO'
775: and peef.assignment_id = p_assignment_id
776: and peef.element_type_id = pet.element_type_id

Line 793: pay_element_entries_f peef,

789: ) is
790: select fnd_date.canonical_to_date (peev.screen_entry_value)
791: from pay_element_types_f pet,
792: pay_input_values_f piv,
793: pay_element_entries_f peef,
794: pay_element_entry_values_f peev
795: where pet.element_name = c_element_name
796: and pet.element_type_id = piv.element_type_id
797: and piv.name = c_input_val_name

Line 947: l_element_entry_id pay_element_entries_f.element_entry_id%type;

943: l_normal_hours number;
944: l_table1 pay_dated_tables.dated_table_id%type;
945: l_table2 pay_dated_tables.dated_table_id%type;
946: l_table3 pay_dated_tables.dated_table_id%type;
947: l_element_entry_id pay_element_entries_f.element_entry_id%type;
948: l_defined_balance_id number;
949: l_get_prev_mon_bal_value number;
950: l_get_current_mon_bal_value number;
951: l_abs_start_date date;

Line 1113: open csr_get_table_id ('PAY_ELEMENT_ENTRIES_F');

1109: --
1110: --
1111:
1112: if g_archive = 'Y' then
1113: open csr_get_table_id ('PAY_ELEMENT_ENTRIES_F');
1114: fetch csr_get_table_id into l_table1;
1115: close csr_get_table_id;
1116: --
1117: --