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 540: from pay_element_entries_f peef, pay_element_types_f pet

536: c_eff_date date,
537: c_element_name varchar2
538: ) is
539: select peef.element_entry_id
540: from pay_element_entries_f peef, pay_element_types_f pet
541: where pet.element_name = c_element_name
542: and pet.legislation_code = 'NO'
543: and peef.assignment_id = c_assignment_id
544: and peef.element_type_id = pet.element_type_id

Line 579: from pay_element_entries_f peef, pay_element_types_f pet

575: c_eff_date date,
576: c_element_name varchar2
577: ) is
578: select peef.element_entry_id
579: from pay_element_entries_f peef, pay_element_types_f pet
580: where pet.element_name = c_element_name
581: and pet.legislation_code = 'NO'
582: and peef.assignment_id = c_assignment_id
583: and peef.element_type_id = pet.element_type_id

Line 596: from pay_element_entries_f peef, pay_element_types_f pet

592: p_end_date date,
593: p_element_name varchar2
594: ) is
595: select peef.element_entry_id
596: from pay_element_entries_f peef, pay_element_types_f pet
597: where pet.element_name = p_element_name
598: and pet.legislation_code = 'NO'
599: and peef.assignment_id = p_assignment_id
600: and peef.element_type_id = pet.element_type_id

Line 617: pay_element_entries_f peef,

613: ) is
614: select fnd_date.canonical_to_date (peev.screen_entry_value)
615: from pay_element_types_f pet,
616: pay_input_values_f piv,
617: pay_element_entries_f peef,
618: pay_element_entry_values_f peev
619: where pet.element_name = c_element_name
620: and pet.element_type_id = piv.element_type_id
621: and piv.name = c_input_val_name

Line 771: l_element_entry_id pay_element_entries_f.element_entry_id%type;

767: l_normal_hours number;
768: l_table1 pay_dated_tables.dated_table_id%type;
769: l_table2 pay_dated_tables.dated_table_id%type;
770: l_table3 pay_dated_tables.dated_table_id%type;
771: l_element_entry_id pay_element_entries_f.element_entry_id%type;
772: l_defined_balance_id number;
773: l_get_prev_mon_bal_value number;
774: l_get_current_mon_bal_value number;
775: l_abs_start_date date;

Line 936: open csr_get_table_id ('PAY_ELEMENT_ENTRIES_F');

932: --
933: --
934:
935: if g_archive = 'Y' then
936: open csr_get_table_id ('PAY_ELEMENT_ENTRIES_F');
937: fetch csr_get_table_id into l_table1;
938: close csr_get_table_id;
939: --
940: --