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

700: c_eff_date date,
701: c_element_name varchar2
702: ) is
703: select peef.element_entry_id
704: from pay_element_entries_f peef, pay_element_types_f pet
705: where pet.element_name = c_element_name
706: and pet.legislation_code = 'NO'
707: and peef.assignment_id = c_assignment_id
708: and peef.element_type_id = pet.element_type_id

Line 756: from pay_element_entries_f peef, pay_element_types_f pet

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

Line 775: from pay_element_entries_f peef, pay_element_types_f pet

771: p_end_date date,
772: p_element_name varchar2
773: ) is
774: select peef.element_entry_id
775: from pay_element_entries_f peef, pay_element_types_f pet
776: where pet.element_name = p_element_name
777: and pet.legislation_code = 'NO'
778: and peef.assignment_id = p_assignment_id
779: 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 1008: l_element_entry_id pay_element_entries_f.element_entry_id%type;

1004: l_normal_hours number;
1005: l_table1 pay_dated_tables.dated_table_id%type;
1006: l_table2 pay_dated_tables.dated_table_id%type;
1007: l_table3 pay_dated_tables.dated_table_id%type;
1008: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1009: l_defined_balance_id number;
1010: l_get_prev_mon_bal_value number;
1011: l_get_current_mon_bal_value number;
1012: l_abs_start_date date;

Line 1175: open csr_get_table_id ('PAY_ELEMENT_ENTRIES_F');

1171:
1172: --
1173: --
1174: if g_archive = 'Y' then
1175: open csr_get_table_id ('PAY_ELEMENT_ENTRIES_F');
1176: fetch csr_get_table_id into l_table1;
1177: close csr_get_table_id;
1178: --
1179: --