APPS.PAY_PAYUSTIM_XMLP_PKG dependencies on PAY_US_RPT_TOTALS

Line 49: from pay_us_rpt_totals

45: l_param,
46: p_business_group_id,
47: p_start_date,
48: p_end_date
49: from pay_us_rpt_totals
50: where organization_id = to_number(PPA_FINDER)
51: and attribute1 = 'TIAA-CREF'
52: and rownum=1;
53:

Line 64: delete from pay_us_rpt_totals where tax_unit_id = pactid;

60: exception when others then
61:
62: /*srw.message(1,'Legislative parameter not found. ERROR');*/null;
63:
64: delete from pay_us_rpt_totals where tax_unit_id = pactid;
65: commit;
66: raise;
67: end;
68:

Line 83: from pay_us_rpt_totals

79:
80: select attribute19
81: into
82: l_flag
83: from pay_us_rpt_totals
84: where tax_unit_id = pactid
85: and attribute1 = 'TIAA-CREF'
86: and rownum=1;
87:

Line 89: delete from pay_us_rpt_totals where tax_unit_id = pactid;

85: and attribute1 = 'TIAA-CREF'
86: and rownum=1;
87:
88: if l_flag ='Y' then
89: delete from pay_us_rpt_totals where tax_unit_id = pactid;
90: commit;
91: else
92:
93: update pay_us_rpt_totals

Line 93: update pay_us_rpt_totals

89: delete from pay_us_rpt_totals where tax_unit_id = pactid;
90: commit;
91: else
92:
93: update pay_us_rpt_totals
94: set attribute19='Y'
95: where tax_unit_id = pactid
96: and attribute1 = 'TIAA-CREF';
97:

Line 139: delete from pay_us_rpt_totals where tax_unit_id = pactid;

135: exception
136: when others then
137: /*srw.message(1,'Legislative parameter not found. ERROR');*/null;
138:
139: delete from pay_us_rpt_totals where tax_unit_id = pactid;
140:
141: raise;
142: end;
143: return (TRUE);

Line 150: from pay_us_rpt_totals purt

146: function cf_1formula(assg_exp in varchar2) return char is
147: cursor err_msg is
148: select
149: distinct attribute15 err_message
150: from pay_us_rpt_totals purt
151: where tax_unit_id =pactid
152: and attribute1<>'TIAA-CREF'
153: and attribute14 is not null
154: and attribute5 = assg_exp;