DBA Data[Home] [Help]

APPS.PAY_GB_PAYE_SYNC dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 128: pay_element_entry_values_f peevf,

124: min(decode(pivf.name, 'Authority', substr(HR_GENERAL.DECODE_LOOKUP('GB_AUTHORITY',peevf.screen_entry_value),1,80),null)) Authority
125: from per_all_people_f papf,
126: per_all_assignments_f paaf,
127: pay_element_entries_f peef,
128: pay_element_entry_values_f peevf,
129: pay_input_values_f pivf,
130: -- per_assignment_status_types past,
131: pay_all_payrolls_f pap,
132: hr_soft_coding_keyflex hsck

Line 173: j_tax_code pay_element_entry_values_f.screen_entry_value%type;

169:
170: j_count number := 0;
171:
172:
173: j_tax_code pay_element_entry_values_f.screen_entry_value%type;
174: j_tax_basis pay_element_entry_values_f.screen_entry_value%type;
175: j_refundable pay_element_entry_values_f.screen_entry_value%type;
176: j_tax_previous pay_element_entry_values_f.screen_entry_value%type;
177: j_pay_previous pay_element_entry_values_f.screen_entry_value%type;

Line 174: j_tax_basis pay_element_entry_values_f.screen_entry_value%type;

170: j_count number := 0;
171:
172:
173: j_tax_code pay_element_entry_values_f.screen_entry_value%type;
174: j_tax_basis pay_element_entry_values_f.screen_entry_value%type;
175: j_refundable pay_element_entry_values_f.screen_entry_value%type;
176: j_tax_previous pay_element_entry_values_f.screen_entry_value%type;
177: j_pay_previous pay_element_entry_values_f.screen_entry_value%type;
178: j_authority pay_element_entry_values_f.screen_entry_value%type;

Line 175: j_refundable pay_element_entry_values_f.screen_entry_value%type;

171:
172:
173: j_tax_code pay_element_entry_values_f.screen_entry_value%type;
174: j_tax_basis pay_element_entry_values_f.screen_entry_value%type;
175: j_refundable pay_element_entry_values_f.screen_entry_value%type;
176: j_tax_previous pay_element_entry_values_f.screen_entry_value%type;
177: j_pay_previous pay_element_entry_values_f.screen_entry_value%type;
178: j_authority pay_element_entry_values_f.screen_entry_value%type;
179:

Line 176: j_tax_previous pay_element_entry_values_f.screen_entry_value%type;

172:
173: j_tax_code pay_element_entry_values_f.screen_entry_value%type;
174: j_tax_basis pay_element_entry_values_f.screen_entry_value%type;
175: j_refundable pay_element_entry_values_f.screen_entry_value%type;
176: j_tax_previous pay_element_entry_values_f.screen_entry_value%type;
177: j_pay_previous pay_element_entry_values_f.screen_entry_value%type;
178: j_authority pay_element_entry_values_f.screen_entry_value%type;
179:
180:

Line 177: j_pay_previous pay_element_entry_values_f.screen_entry_value%type;

173: j_tax_code pay_element_entry_values_f.screen_entry_value%type;
174: j_tax_basis pay_element_entry_values_f.screen_entry_value%type;
175: j_refundable pay_element_entry_values_f.screen_entry_value%type;
176: j_tax_previous pay_element_entry_values_f.screen_entry_value%type;
177: j_pay_previous pay_element_entry_values_f.screen_entry_value%type;
178: j_authority pay_element_entry_values_f.screen_entry_value%type;
179:
180:
181: paye_sync_eff_date EXCEPTION; -- raised when effective date is not between Tax start yeat and sysdate

Line 178: j_authority pay_element_entry_values_f.screen_entry_value%type;

174: j_tax_basis pay_element_entry_values_f.screen_entry_value%type;
175: j_refundable pay_element_entry_values_f.screen_entry_value%type;
176: j_tax_previous pay_element_entry_values_f.screen_entry_value%type;
177: j_pay_previous pay_element_entry_values_f.screen_entry_value%type;
178: j_authority pay_element_entry_values_f.screen_entry_value%type;
179:
180:
181: paye_sync_eff_date EXCEPTION; -- raised when effective date is not between Tax start yeat and sysdate
182:

Line 205: pay_element_entry_values_f eev,

201: min(decode(inv.name, 'Tax Previous', nvl(eev.screen_entry_value,0), null)) Tax_Previous,
202: min(decode(inv.name, 'Authority', eev.screen_entry_value, null)) Authority,
203: pay_gb_eoy_archive.get_agg_active_start (paaf.assignment_id, l_tax_ref,l_effective_date) cpe_date
204: FROM pay_element_entries_f ele,
205: pay_element_entry_values_f eev,
206: pay_input_values_f inv,
207: pay_element_links_f lnk,
208: pay_element_types_f elt,
209: pay_all_payrolls_f papf,

Line 673: tax_code pay_element_entry_values_f.screen_entry_value%type,

669: eef_object_version_number pay_element_entries_f.object_version_number%type,
670: element_entry_id pay_element_entries_f.element_entry_id%type,
671: creator_id pay_element_entries_f.creator_id%type,
672: tax_code_iv_id pay_input_values_f.input_value_id%type,
673: tax_code pay_element_entry_values_f.screen_entry_value%type,
674: tax_basis_iv_id pay_input_values_f.input_value_id%type,
675: tax_basis pay_element_entry_values_f.screen_entry_value%type,
676: pay_previous_iv_id pay_input_values_f.input_value_id%type,
677: pay_previous pay_element_entry_values_f.screen_entry_value%type,

Line 675: tax_basis pay_element_entry_values_f.screen_entry_value%type,

671: creator_id pay_element_entries_f.creator_id%type,
672: tax_code_iv_id pay_input_values_f.input_value_id%type,
673: tax_code pay_element_entry_values_f.screen_entry_value%type,
674: tax_basis_iv_id pay_input_values_f.input_value_id%type,
675: tax_basis pay_element_entry_values_f.screen_entry_value%type,
676: pay_previous_iv_id pay_input_values_f.input_value_id%type,
677: pay_previous pay_element_entry_values_f.screen_entry_value%type,
678: tax_previous_iv_id pay_input_values_f.input_value_id%type,
679: tax_previous pay_element_entry_values_f.screen_entry_value%type,

Line 677: pay_previous pay_element_entry_values_f.screen_entry_value%type,

673: tax_code pay_element_entry_values_f.screen_entry_value%type,
674: tax_basis_iv_id pay_input_values_f.input_value_id%type,
675: tax_basis pay_element_entry_values_f.screen_entry_value%type,
676: pay_previous_iv_id pay_input_values_f.input_value_id%type,
677: pay_previous pay_element_entry_values_f.screen_entry_value%type,
678: tax_previous_iv_id pay_input_values_f.input_value_id%type,
679: tax_previous pay_element_entry_values_f.screen_entry_value%type,
680: authority_iv_id pay_input_values_f.input_value_id%type,
681: authority pay_element_entry_values_f.screen_entry_value%type,

Line 679: tax_previous pay_element_entry_values_f.screen_entry_value%type,

675: tax_basis pay_element_entry_values_f.screen_entry_value%type,
676: pay_previous_iv_id pay_input_values_f.input_value_id%type,
677: pay_previous pay_element_entry_values_f.screen_entry_value%type,
678: tax_previous_iv_id pay_input_values_f.input_value_id%type,
679: tax_previous pay_element_entry_values_f.screen_entry_value%type,
680: authority_iv_id pay_input_values_f.input_value_id%type,
681: authority pay_element_entry_values_f.screen_entry_value%type,
682: refundable_iv_id pay_input_values_f.input_value_id%type,
683: refundable pay_element_entry_values_f.screen_entry_value%type

Line 681: authority pay_element_entry_values_f.screen_entry_value%type,

677: pay_previous pay_element_entry_values_f.screen_entry_value%type,
678: tax_previous_iv_id pay_input_values_f.input_value_id%type,
679: tax_previous pay_element_entry_values_f.screen_entry_value%type,
680: authority_iv_id pay_input_values_f.input_value_id%type,
681: authority pay_element_entry_values_f.screen_entry_value%type,
682: refundable_iv_id pay_input_values_f.input_value_id%type,
683: refundable pay_element_entry_values_f.screen_entry_value%type
684: );
685:

Line 683: refundable pay_element_entry_values_f.screen_entry_value%type

679: tax_previous pay_element_entry_values_f.screen_entry_value%type,
680: authority_iv_id pay_input_values_f.input_value_id%type,
681: authority pay_element_entry_values_f.screen_entry_value%type,
682: refundable_iv_id pay_input_values_f.input_value_id%type,
683: refundable pay_element_entry_values_f.screen_entry_value%type
684: );
685:
686: cursor get_element_type_id
687: is

Line 725: pay_element_entry_values_f eev,

721: min(decode(inv.name, 'Refundable', eev.screen_entry_value, null)) refundable_sv
722: from per_all_people_f papf,
723: per_all_assignments_f paaf,
724: pay_element_entries_f peef,
725: pay_element_entry_values_f eev,
726: pay_input_values_f inv,
727: pay_all_payrolls_f pap,
728: per_periods_of_service ppos, -- Added for considering Terminated Employees till FPD
729: hr_soft_coding_keyflex flex