APPS.PAY_NO_EERR_CONTINUOUS dependencies on PAY_ELEMENT_ENTRIES_F

Line 29: element_entry_id pay_element_entries_f.element_entry_id%type,

25: new_value varchar2(2000),
26: change_values varchar2(2000),
27: proration_type varchar2(10),
28: change_mode pay_process_events.change_type%type,--'DATE_PROCESSED' etc
29: element_entry_id pay_element_entries_f.element_entry_id%type,
30: next_ee number ,
31: assignment_id per_all_Assignments_f.assignment_id%type
32: );
33:

Line 538: from pay_element_entries_f peef, pay_element_types_f pet

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

Line 590: from pay_element_entries_f peef, pay_element_types_f pet

586: c_eff_date date,
587: c_element_name varchar2
588: ) is
589: select peef.element_entry_id
590: from pay_element_entries_f peef, pay_element_types_f pet
591: where pet.element_name = c_element_name
592: and pet.legislation_code = 'NO'
593: and peef.assignment_id = c_assignment_id
594: and peef.element_type_id = pet.element_type_id

Line 609: from pay_element_entries_f peef, pay_element_types_f pet

605: p_end_date date,
606: p_element_name varchar2
607: ) is
608: select peef.element_entry_id
609: from pay_element_entries_f peef, pay_element_types_f pet
610: where pet.element_name = p_element_name
611: and pet.legislation_code = 'NO'
612: and peef.assignment_id = p_assignment_id
613: and peef.element_type_id = pet.element_type_id

Line 627: pay_element_entries_f peef,

623: ) is
624: select fnd_date.canonical_to_date (peev.screen_entry_value)
625: from pay_element_types_f pet,
626: pay_input_values_f piv,
627: pay_element_entries_f peef,
628: pay_element_entry_values_f peev
629: where pet.element_name = c_element_name
630: and pet.element_type_id = piv.element_type_id
631: and piv.name = c_input_val_name

Line 842: l_element_entry_id pay_element_entries_f.element_entry_id%type;

838: l_normal_hours number;
839: l_table1 pay_dated_tables.dated_table_id%type;
840: l_table2 pay_dated_tables.dated_table_id%type;
841: l_table3 pay_dated_tables.dated_table_id%type;
842: l_element_entry_id pay_element_entries_f.element_entry_id%type;
843: l_defined_balance_id number;
844: l_get_prev_mon_bal_value number;
845: l_get_current_mon_bal_value number;
846: l_abs_start_date date;

Line 1009: open csr_get_table_id ('PAY_ELEMENT_ENTRIES_F');

1005:
1006: --
1007: --
1008: if g_archive = 'Y' then
1009: open csr_get_table_id ('PAY_ELEMENT_ENTRIES_F');
1010: fetch csr_get_table_id into l_table1;
1011: close csr_get_table_id;
1012: --
1013: --