[Home] [Help]
28: local taxes being reporting incorrectly.
29: Bug 2060255. Modified the load_message
30: lines routine, adding a cursor look around
31: the outer cursor, to check each row in the
32: pay_pre_payments table With Out payments.
33: 19-FEB-2002 tclewis 115.9 Change label "Number of Incomplete Payments'
34: to "Incomplete Payments" and
35: "Number of Complete Payments" back to
36: "Disbursements".
39: removed the join with column paa_year_effective_date as
40: the view pay_us_local_taxes_v has been changed (removed the
41: inline view).
42: 10-JUL-2002 tclewis 115.12 modified load_prepay, when inserting data into
43: pay_us_rpt_totals also load pay_pre_payments.pre_payment_id
44: into the pay_us_rpt_totals.location_id (an indexed column).
45: New logic to look for the Pre_payment_id in the table
46: before inserting. This will eliminate duplicates.
47: added same functionality to load_mesg_line for the count
1679: pay_external_accounts pea,
1680: pay_personal_payment_methods_f pppm,
1681: pay_org_payment_methods_f popm,
1682: pay_payment_types ppt,
1683: pay_pre_payments ppp
1684: where fcl.application_id(+) = 800
1685: and fcl.lookup_type(+) = 'US_ACCOUNT_TYPE'
1686: and pea.segment2 = fcl.lookup_code(+)
1687: and pea.external_account_id(+) = pppm.external_account_id
1699: and ppp.pre_payment_id = l_ppp_pre_payment_id;
1700:
1701: cursor ppp_action is
1702: select ppp.pre_payment_id pre_payment_id
1703: from pay_pre_payments ppp,
1704: pay_payroll_actions ppa_ppp,
1705: pay_assignment_actions paa_ppp,
1706: pay_action_interlocks pai
1707: where pai.locked_action_id = l_assignment_action_id
1886: PAY_PAYROLL_ACTIONS PPA_CHK,
1887: PAY_ASSIGNMENT_ACTIONS PAA_CHK,
1888: PAY_ACTION_INTERLOCKS PAI_CHK,
1889: PAY_ORG_PAYMENT_METHODS_F POPM,
1890: PAY_PRE_PAYMENTS PPP
1891: WHERE PAI_RUN.LOCKED_ACTION_ID = p_max_seq_aaid
1892: AND PAI_RUN.LOCKING_ACTION_ID = PAA_PPP.ASSIGNMENT_ACTION_ID
1893: AND PAA_PPP.ACTION_STATUS = 'C'
1894: AND PAA_PPP.PAYROLL_ACTION_ID = PPA_PPP.PAYROLL_ACTION_ID