DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ERROR dependencies on PAY_US_RPT_TOTALS

Line 1072: insert into pay_us_rpt_totals (gre_name,

1068: close c_state;
1069:
1070: if lv_state_abbrev = 'CA' then
1071:
1072: insert into pay_us_rpt_totals (gre_name,
1073: organization_name,
1074: attribute2,
1075: attribute3,
1076: attribute30)

Line 1082: insert into pay_us_rpt_totals (gre_name,

1078: 'No assignment actions have been created by the State quarterly Wage listing process.State Tax Rules may not have been defined properly','For California there could a setup issue related with Single/Multiple Wage plan',
1079: 'STATE_QUARTERLY_ERROR_REPORT');
1080: else
1081:
1082: insert into pay_us_rpt_totals (gre_name,
1083: organization_name,
1084: attribute2,
1085: attribute30)
1086: values(p_qtrname,lv_state_abbrev,

Line 2054: hr_utility.trace('Inserted header in pay_us_rpt_totals');

2050: if lv_neg_asg_count = 1 then
2051:
2052: fnd_file.put_line(fnd_file.output,formated_Static_header('CSV'));
2053:
2054: hr_utility.trace('Inserted header in pay_us_rpt_totals');
2055:
2056: end if;
2057:
2058:

Line 2094: hr_utility.trace('Inserted header in pay_us_rpt_totals');

2090: if lv_neg_asg_count = 1 then
2091:
2092: fnd_file.put_line(fnd_file.output,formated_Static_header('CSV'));
2093:
2094: hr_utility.trace('Inserted header in pay_us_rpt_totals');
2095:
2096: end if;
2097:
2098: