eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_PAYE_SYNC dependencies on HR_GENERAL

Line 119: -- min(decode(pivf.name, 'Tax Basis', substr(HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',peevf.screen_entry_value),1,80),null)) Tax_Basis,

115: peef.effective_start_date effst,
116: peef.effective_end_date effend,
117: peef.object_version_number ovn,
118: min(decode(pivf.name, 'Tax Code', peevf.screen_entry_value, null)) Tax_Code,
119: -- min(decode(pivf.name, 'Tax Basis', substr(HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',peevf.screen_entry_value),1,80),null)) Tax_Basis,
120: min(decode(pivf.name, 'Tax Basis',peevf.screen_entry_value,null)) Tax_Basis,
121: min(decode(pivf.name, 'Refundable', substr(HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',peevf.screen_entry_value),1,80),null)) Refundable,
122: hr_chkfmt.changeformat(nvl(min(decode(pivf.name, 'Pay Previous', peevf.screen_entry_value, null)), 0), 'M', 'GBP') Pay_Previous,
123: hr_chkfmt.changeformat(nvl(min(decode(pivf.name, 'Tax Previous', peevf.screen_entry_value, null)), 0), 'M', 'GBP') Tax_Previous,

Line 121: min(decode(pivf.name, 'Refundable', substr(HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',peevf.screen_entry_value),1,80),null)) Refundable,

117: peef.object_version_number ovn,
118: min(decode(pivf.name, 'Tax Code', peevf.screen_entry_value, null)) Tax_Code,
119: -- min(decode(pivf.name, 'Tax Basis', substr(HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',peevf.screen_entry_value),1,80),null)) Tax_Basis,
120: min(decode(pivf.name, 'Tax Basis',peevf.screen_entry_value,null)) Tax_Basis,
121: min(decode(pivf.name, 'Refundable', substr(HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',peevf.screen_entry_value),1,80),null)) Refundable,
122: hr_chkfmt.changeformat(nvl(min(decode(pivf.name, 'Pay Previous', peevf.screen_entry_value, null)), 0), 'M', 'GBP') Pay_Previous,
123: hr_chkfmt.changeformat(nvl(min(decode(pivf.name, 'Tax Previous', peevf.screen_entry_value, null)), 0), 'M', 'GBP') Tax_Previous,
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,

Line 124: min(decode(pivf.name, 'Authority', substr(HR_GENERAL.DECODE_LOOKUP('GB_AUTHORITY',peevf.screen_entry_value),1,80),null)) Authority

120: min(decode(pivf.name, 'Tax Basis',peevf.screen_entry_value,null)) Tax_Basis,
121: min(decode(pivf.name, 'Refundable', substr(HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',peevf.screen_entry_value),1,80),null)) Refundable,
122: hr_chkfmt.changeformat(nvl(min(decode(pivf.name, 'Pay Previous', peevf.screen_entry_value, null)), 0), 'M', 'GBP') Pay_Previous,
123: hr_chkfmt.changeformat(nvl(min(decode(pivf.name, 'Tax Previous', peevf.screen_entry_value, null)), 0), 'M', 'GBP') Tax_Previous,
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,

Line 829: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_basis||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',db_rec.tax_basis));

825: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).effective_end_date||'::DB-'||db_rec.effective_end_date);
826: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).cpe_start_date||'::DB-'||db_rec.cpe_start_date);
827: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).peef_ovn||'::DB-'||db_rec.eef_object_version_number);
828: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_code||'::DB-'||db_rec.tax_code);
829: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_basis||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',db_rec.tax_basis));
830: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).refundable||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',db_rec.refundable));
831: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).previous_pay||'::DB-'||nvl(db_rec.pay_previous,0));
832: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).previous_tax||'::DB-'||nvl(db_rec.tax_previous,0));
833: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).authority||'::DB-'||db_rec.authority);

Line 830: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).refundable||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',db_rec.refundable));

826: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).cpe_start_date||'::DB-'||db_rec.cpe_start_date);
827: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).peef_ovn||'::DB-'||db_rec.eef_object_version_number);
828: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_code||'::DB-'||db_rec.tax_code);
829: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).tax_basis||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',db_rec.tax_basis));
830: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).refundable||'::DB-'||HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',db_rec.refundable));
831: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).previous_pay||'::DB-'||nvl(db_rec.pay_previous,0));
832: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).previous_tax||'::DB-'||nvl(db_rec.tax_previous,0));
833: hr_utility.trace( l_pkg ||'FILE-'||tab_paye_file(l_count).authority||'::DB-'||db_rec.authority);
834: /* End Debug information */

Line 845: (nvl(tab_paye_file(l_count).tax_basis,'NULL') = nvl(HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',db_rec.tax_basis),'NULL')) and

841: (tab_paye_file(l_count).effective_end_date = db_rec.effective_end_date) and
842: (tab_paye_file(l_count).cpe_start_date = db_rec.cpe_start_date) and
843: (nvl(tab_paye_file(l_count).peef_ovn, -1) = db_rec.eef_object_version_number) and
844: (nvl(tab_paye_file(l_count).tax_code,'NULL') = nvl(db_rec.tax_code,'NULL')) and
845: (nvl(tab_paye_file(l_count).tax_basis,'NULL') = nvl(HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',db_rec.tax_basis),'NULL')) and
846: (nvl(tab_paye_file(l_count).refundable,'NULL') = nvl(HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',db_rec.refundable),'NULL')) and
847: (nvl(tab_paye_file(l_count).previous_pay,0) = nvl(db_rec.pay_previous,0)) and
848: (nvl(tab_paye_file(l_count).previous_tax,0) = nvl(db_rec.tax_previous,0)) and
849: (nvl(tab_paye_file(l_count).authority,'NULL') = nvl(db_rec.authority,'NULL'))

Line 846: (nvl(tab_paye_file(l_count).refundable,'NULL') = nvl(HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',db_rec.refundable),'NULL')) and

842: (tab_paye_file(l_count).cpe_start_date = db_rec.cpe_start_date) and
843: (nvl(tab_paye_file(l_count).peef_ovn, -1) = db_rec.eef_object_version_number) and
844: (nvl(tab_paye_file(l_count).tax_code,'NULL') = nvl(db_rec.tax_code,'NULL')) and
845: (nvl(tab_paye_file(l_count).tax_basis,'NULL') = nvl(HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',db_rec.tax_basis),'NULL')) and
846: (nvl(tab_paye_file(l_count).refundable,'NULL') = nvl(HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',db_rec.refundable),'NULL')) and
847: (nvl(tab_paye_file(l_count).previous_pay,0) = nvl(db_rec.pay_previous,0)) and
848: (nvl(tab_paye_file(l_count).previous_tax,0) = nvl(db_rec.tax_previous,0)) and
849: (nvl(tab_paye_file(l_count).authority,'NULL') = nvl(db_rec.authority,'NULL'))
850: )

Line 854: tab_paye_file(l_count).sug_tax_basis = HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',db_rec.tax_basis) and

850: )
851: THEN
852:
853: IF(tab_paye_file(l_count).sug_tax_code = db_rec.tax_code and
854: tab_paye_file(l_count).sug_tax_basis = HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',db_rec.tax_basis) and
855: tab_paye_file(l_count).sug_refundable = HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',db_rec.refundable) and
856: tab_paye_file(l_count).sug_previous_pay = nvl(db_rec.pay_previous,0) and
857: tab_paye_file(l_count).sug_previous_tax = nvl(db_rec.tax_previous,0) and
858: nvl(tab_paye_file(l_count).sug_authority,'NULL') = nvl(db_rec.authority,'NULL')

Line 855: tab_paye_file(l_count).sug_refundable = HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',db_rec.refundable) and

851: THEN
852:
853: IF(tab_paye_file(l_count).sug_tax_code = db_rec.tax_code and
854: tab_paye_file(l_count).sug_tax_basis = HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',db_rec.tax_basis) and
855: tab_paye_file(l_count).sug_refundable = HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE',db_rec.refundable) and
856: tab_paye_file(l_count).sug_previous_pay = nvl(db_rec.pay_previous,0) and
857: tab_paye_file(l_count).sug_previous_tax = nvl(db_rec.tax_previous,0) and
858: nvl(tab_paye_file(l_count).sug_authority,'NULL') = nvl(db_rec.authority,'NULL')
859: )

Line 1190: tab_paye_file(l_record_no).tax_basis := HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',tab_paye_file(l_record_no).tax_basis);

1186: tab_paye_file(l_record_no).effective_end_date := to_date(get_token(l_present_line,19),v_date_format);
1187: tab_paye_file(l_record_no).peef_ovn := get_token(l_present_line,20);
1188:
1189:
1190: tab_paye_file(l_record_no).tax_basis := HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',tab_paye_file(l_record_no).tax_basis);
1191: tab_paye_file(l_record_no).sug_tax_basis := HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',tab_paye_file(l_record_no).sug_tax_basis);
1192:
1193: hr_utility.trace( l_pkg ||'last_name:'||tab_paye_file(l_record_no).last_name);
1194: hr_utility.trace( l_pkg ||'person_id:'||tab_paye_file(l_record_no).person_id);

Line 1191: tab_paye_file(l_record_no).sug_tax_basis := HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',tab_paye_file(l_record_no).sug_tax_basis);

1187: tab_paye_file(l_record_no).peef_ovn := get_token(l_present_line,20);
1188:
1189:
1190: tab_paye_file(l_record_no).tax_basis := HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',tab_paye_file(l_record_no).tax_basis);
1191: tab_paye_file(l_record_no).sug_tax_basis := HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS',tab_paye_file(l_record_no).sug_tax_basis);
1192:
1193: hr_utility.trace( l_pkg ||'last_name:'||tab_paye_file(l_record_no).last_name);
1194: hr_utility.trace( l_pkg ||'person_id:'||tab_paye_file(l_record_no).person_id);
1195: hr_utility.trace( l_pkg ||'assignment_id:'||tab_paye_file(l_record_no).assignment_id);