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_US_SQWL_ARCHIVE dependencies on PAY_BALANCE_PKG

Line 561: pay_balance_pkg.get_value(bal_db_item('GROSS_EARNINGS_PER_GRE_QTD'),

557:
558: hr_utility.trace('l_resides_true =' || l_resides_true);
559:
560: IF (l_resides_true = '1' AND
561: pay_balance_pkg.get_value(bal_db_item('GROSS_EARNINGS_PER_GRE_QTD'),
562: p_assignment_id, least(p_period_end, p_effective_end_date)) <> 0) THEN
563:
564: hr_utility.trace('Returning TRUE from check_residence_state');
565:

Line 613: l_ret_value := (pay_balance_pkg.get_value(

609: IF (p_state = 'CA') THEN
610:
611: IF (p_1099R_ind = 'Y') THEN
612:
613: l_ret_value := (pay_balance_pkg.get_value(
614: bal_db_item('SIT_WITHHELD_PER_JD_GRE_QTD') , p_assignment_id,
615: least(p_period_end, p_effective_end_date)) <> 0 );
616:
617:

Line 620: l_ret_value := (pay_balance_pkg.get_value(

616:
617:
618: ELSE
619:
620: l_ret_value := (pay_balance_pkg.get_value(
621: bal_db_item('SIT_GROSS_PER_JD_GRE_QTD') , p_assignment_id,
622: least(p_period_end, p_effective_end_date)) <> 0 );
623:
624: END IF;

Line 630: l_ret_value := (pay_balance_pkg.get_value(

626: /* Check for ME Bug# 4310812 */
627: IF (p_state = 'ME') THEN
628: IF (p_1099R_ind = 'Y') THEN
629:
630: l_ret_value := (pay_balance_pkg.get_value(
631: bal_db_item('SIT_SUBJ_WHABLE_PER_JD_GRE_QTD') , p_assignment_id,
632: least(p_period_end, p_effective_end_date)) <> 0 );
633: END IF ;
634: END IF ;

Line 1317: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);

1313: --
1314: -- Set up TAX_UNIT_ID context if appropriate.
1315: --
1316: if l_tax_unit_context then
1317: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
1318: end if;
1319: --
1320: -- Set up JURISDICTION_CODE context if appropriate.
1321: --

Line 1323: pay_balance_pkg.set_context('JURISDICTION_CODE',l_jurisdiction_code);

1319: --
1320: -- Set up JURISDICTION_CODE context if appropriate.
1321: --
1322: if l_jurisdiction_context then
1323: pay_balance_pkg.set_context('JURISDICTION_CODE',l_jurisdiction_code);
1324: end if;
1325: --
1326: --
1327: -- Check the balance.

Line 1343: l_value := pay_balance_pkg.get_value

1339: l_1099R_ind := null;
1340: end;
1341: end if;
1342: if (nvl(l_1099R_ind, 'N') <> 'Y') then
1343: l_value := pay_balance_pkg.get_value
1344: (l_defined_balance_id,
1345: l_assignment_id,
1346: least(l_period_end,l_effective_end_date));
1347: --4310812

Line 1349: l_value_sit := pay_balance_pkg.get_value(bal_db_item('SIT_SUBJ_WHABLE_PER_JD_GRE_QTD') ,

1345: l_assignment_id,
1346: least(l_period_end,l_effective_end_date));
1347: --4310812
1348: If l_state = 'ME' Then
1349: l_value_sit := pay_balance_pkg.get_value(bal_db_item('SIT_SUBJ_WHABLE_PER_JD_GRE_QTD') ,
1350: l_assignment_id,
1351: least(l_period_end, l_effective_end_date)) ;
1352:
1353: If nvl(l_value,0) <> 0 and nvl(l_value_sit,0) <> 0 Then

Line 1369: l_value := pay_balance_pkg.get_value

1365: if instr(to_char(l_quarter_end,'MM'), '12') <> 0 then /*Check for Last Quarter*/
1366:
1367: hr_utility.trace('Last Quarter.Check the values for SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD');
1368:
1369: l_value := pay_balance_pkg.get_value
1370: (bal_db_item('SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD'),
1371: l_assignment_id,
1372: least(l_period_end,l_effective_end_date));
1373:

Line 1388: l_value := pay_balance_pkg.get_value

1384: l_value := 0;
1385:
1386: ELSE
1387:
1388: l_value := pay_balance_pkg.get_value
1389: (bal_db_item('SUI_ER_SUBJ_WHABLE_PER_JD_GRE_QTD'),
1390: l_assignment_id,
1391: least(l_period_end,l_effective_end_date));
1392:

Line 1548: pay_balance_pkg.set_context ('JURISDICTION_CODE',jurisdiction_code);

1544: /* Added the g_report_cat variable on 10-FEB-2000 by Ashu Gupta (ashgupta).
1545: This variable will be used in archive_data procedure to decide the report
1546: category */
1547:
1548: pay_balance_pkg.set_context ('JURISDICTION_CODE',jurisdiction_code);
1549: END IF;
1550: /* Bug 773937 */
1551: hr_utility.set_location ('archinit getting min chunk number',10);
1552: open c_get_min_chunk;

Line 2271: pay_balance_pkg.set_context ('ASSIGNMENT_ID', asgid);

2267: /* End of Bug 773937 */
2268:
2269: /* Setup contexts */
2270:
2271: pay_balance_pkg.set_context ('ASSIGNMENT_ID', asgid);
2272: pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned));
2273: /* pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned,'DD-MON-YYYY')); date format not required */
2274: pay_balance_pkg.set_context ('TAX_UNIT_ID', taxunitid);
2275:

Line 2272: pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned));

2268:
2269: /* Setup contexts */
2270:
2271: pay_balance_pkg.set_context ('ASSIGNMENT_ID', asgid);
2272: pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned));
2273: /* pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned,'DD-MON-YYYY')); date format not required */
2274: pay_balance_pkg.set_context ('TAX_UNIT_ID', taxunitid);
2275:
2276: /* Get the year begin and year end dates */

Line 2273: /* pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned,'DD-MON-YYYY')); date format not required */

2269: /* Setup contexts */
2270:
2271: pay_balance_pkg.set_context ('ASSIGNMENT_ID', asgid);
2272: pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned));
2273: /* pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned,'DD-MON-YYYY')); date format not required */
2274: pay_balance_pkg.set_context ('TAX_UNIT_ID', taxunitid);
2275:
2276: /* Get the year begin and year end dates */
2277:

Line 2274: pay_balance_pkg.set_context ('TAX_UNIT_ID', taxunitid);

2270:
2271: pay_balance_pkg.set_context ('ASSIGNMENT_ID', asgid);
2272: pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned));
2273: /* pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned,'DD-MON-YYYY')); date format not required */
2274: pay_balance_pkg.set_context ('TAX_UNIT_ID', taxunitid);
2275:
2276: /* Get the year begin and year end dates */
2277:
2278: l_year_start := trunc(p_effective_date, 'Y');

Line 2365: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',aaid);

2361: set serial_number = 1
2362: where paa.assignment_action_id = p_assactid;
2363: END IF;
2364: END IF;
2365: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',aaid);
2366: pay_archive.balance_aa := aaid;
2367:
2368: end archive_data;
2369: