APPS.PAY_KR_PAYKRYTS_PKG dependencies on FF_ARCHIVE_ITEMS

Line 49: from ff_archive_items i8, /* X_YEA_ITAX_ADJ */

45: nvl(sum(to_number(i6.value)), 0) PREV_ITAX,
46: nvl(sum(to_number(i7.value)), 0) CUR_ITAX,
47: nvl(sum(decode(sign(to_number(i8.value)), 1, to_number(i8.value),null)), 0) ITAX_ADJ_PAY,
48: abs(nvl(sum(decode(sign(to_number(i8.value)), -1, to_number(i8.value),null)), 0)) ITAX_ADJ_REFUND
49: from ff_archive_items i8, /* X_YEA_ITAX_ADJ */
50: ff_archive_items i7, /* X_YEA_CUR_ITAX */
51: ff_archive_items i6, /* X_YEA_PREV_ITAX */
52: ff_archive_items i5, /* X_YEA_ANNUAL_ITAX */
53: ff_archive_items i4, /* X_YEA_DONATION_TAX_EXEM */

Line 50: ff_archive_items i7, /* X_YEA_CUR_ITAX */

46: nvl(sum(to_number(i7.value)), 0) CUR_ITAX,
47: nvl(sum(decode(sign(to_number(i8.value)), 1, to_number(i8.value),null)), 0) ITAX_ADJ_PAY,
48: abs(nvl(sum(decode(sign(to_number(i8.value)), -1, to_number(i8.value),null)), 0)) ITAX_ADJ_REFUND
49: from ff_archive_items i8, /* X_YEA_ITAX_ADJ */
50: ff_archive_items i7, /* X_YEA_CUR_ITAX */
51: ff_archive_items i6, /* X_YEA_PREV_ITAX */
52: ff_archive_items i5, /* X_YEA_ANNUAL_ITAX */
53: ff_archive_items i4, /* X_YEA_DONATION_TAX_EXEM */
54: ff_archive_items i3, /* X_YEA_MED_EXP_TAX_EXEM */

Line 51: ff_archive_items i6, /* X_YEA_PREV_ITAX */

47: nvl(sum(decode(sign(to_number(i8.value)), 1, to_number(i8.value),null)), 0) ITAX_ADJ_PAY,
48: abs(nvl(sum(decode(sign(to_number(i8.value)), -1, to_number(i8.value),null)), 0)) ITAX_ADJ_REFUND
49: from ff_archive_items i8, /* X_YEA_ITAX_ADJ */
50: ff_archive_items i7, /* X_YEA_CUR_ITAX */
51: ff_archive_items i6, /* X_YEA_PREV_ITAX */
52: ff_archive_items i5, /* X_YEA_ANNUAL_ITAX */
53: ff_archive_items i4, /* X_YEA_DONATION_TAX_EXEM */
54: ff_archive_items i3, /* X_YEA_MED_EXP_TAX_EXEM */
55: ff_archive_items i2, /* X_YEA_NON_TAXABLE */

Line 52: ff_archive_items i5, /* X_YEA_ANNUAL_ITAX */

48: abs(nvl(sum(decode(sign(to_number(i8.value)), -1, to_number(i8.value),null)), 0)) ITAX_ADJ_REFUND
49: from ff_archive_items i8, /* X_YEA_ITAX_ADJ */
50: ff_archive_items i7, /* X_YEA_CUR_ITAX */
51: ff_archive_items i6, /* X_YEA_PREV_ITAX */
52: ff_archive_items i5, /* X_YEA_ANNUAL_ITAX */
53: ff_archive_items i4, /* X_YEA_DONATION_TAX_EXEM */
54: ff_archive_items i3, /* X_YEA_MED_EXP_TAX_EXEM */
55: ff_archive_items i2, /* X_YEA_NON_TAXABLE */
56: ff_archive_items i1, /* X_YEA_TAXABLE */

Line 53: ff_archive_items i4, /* X_YEA_DONATION_TAX_EXEM */

49: from ff_archive_items i8, /* X_YEA_ITAX_ADJ */
50: ff_archive_items i7, /* X_YEA_CUR_ITAX */
51: ff_archive_items i6, /* X_YEA_PREV_ITAX */
52: ff_archive_items i5, /* X_YEA_ANNUAL_ITAX */
53: ff_archive_items i4, /* X_YEA_DONATION_TAX_EXEM */
54: ff_archive_items i3, /* X_YEA_MED_EXP_TAX_EXEM */
55: ff_archive_items i2, /* X_YEA_NON_TAXABLE */
56: ff_archive_items i1, /* X_YEA_TAXABLE */
57: pay_assignment_actions paa,

Line 54: ff_archive_items i3, /* X_YEA_MED_EXP_TAX_EXEM */

50: ff_archive_items i7, /* X_YEA_CUR_ITAX */
51: ff_archive_items i6, /* X_YEA_PREV_ITAX */
52: ff_archive_items i5, /* X_YEA_ANNUAL_ITAX */
53: ff_archive_items i4, /* X_YEA_DONATION_TAX_EXEM */
54: ff_archive_items i3, /* X_YEA_MED_EXP_TAX_EXEM */
55: ff_archive_items i2, /* X_YEA_NON_TAXABLE */
56: ff_archive_items i1, /* X_YEA_TAXABLE */
57: pay_assignment_actions paa,
58: pay_payroll_actions ppa,

Line 55: ff_archive_items i2, /* X_YEA_NON_TAXABLE */

51: ff_archive_items i6, /* X_YEA_PREV_ITAX */
52: ff_archive_items i5, /* X_YEA_ANNUAL_ITAX */
53: ff_archive_items i4, /* X_YEA_DONATION_TAX_EXEM */
54: ff_archive_items i3, /* X_YEA_MED_EXP_TAX_EXEM */
55: ff_archive_items i2, /* X_YEA_NON_TAXABLE */
56: ff_archive_items i1, /* X_YEA_TAXABLE */
57: pay_assignment_actions paa,
58: pay_payroll_actions ppa,
59: hr_organization_units hou

Line 56: ff_archive_items i1, /* X_YEA_TAXABLE */

52: ff_archive_items i5, /* X_YEA_ANNUAL_ITAX */
53: ff_archive_items i4, /* X_YEA_DONATION_TAX_EXEM */
54: ff_archive_items i3, /* X_YEA_MED_EXP_TAX_EXEM */
55: ff_archive_items i2, /* X_YEA_NON_TAXABLE */
56: ff_archive_items i1, /* X_YEA_TAXABLE */
57: pay_assignment_actions paa,
58: pay_payroll_actions ppa,
59: hr_organization_units hou
60: where hou.organization_id = p_tax_unit_id