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 625: pay_balance_pkg.get_value(bal_db_item('GROSS_EARNINGS_PER_GRE_QTD'),

621:
622: hr_utility.trace('l_resides_true =' || l_resides_true);
623:
624: IF (l_resides_true = '1' AND
625: pay_balance_pkg.get_value(bal_db_item('GROSS_EARNINGS_PER_GRE_QTD'),
626: p_assignment_id, least(p_period_end, p_effective_end_date)) <> 0) THEN
627:
628: hr_utility.trace('Returning TRUE from check_residence_state');
629:

Line 678: l_ret_value := (pay_balance_pkg.get_value(

674: IF (p_state = 'CA') THEN
675:
676: IF (p_1099R_ind = 'Y') THEN
677:
678: l_ret_value := (pay_balance_pkg.get_value(
679: bal_db_item('SIT_WITHHELD_PER_JD_GRE_QTD') , p_assignment_id,
680: least(p_period_end, p_effective_end_date)) <> 0 );
681:
682:

Line 685: l_ret_value := (pay_balance_pkg.get_value(

681:
682:
683: ELSE
684:
685: l_ret_value := (pay_balance_pkg.get_value(
686: bal_db_item('SIT_GROSS_PER_JD_GRE_QTD') , p_assignment_id,
687: least(p_period_end, p_effective_end_date)) <> 0 );
688:
689: END IF;

Line 695: l_ret_value := (pay_balance_pkg.get_value(

691: /* Check for ME Bug# 4310812 */
692: IF (p_state = 'ME') THEN
693: IF (p_1099R_ind = 'Y') THEN
694:
695: l_ret_value := (pay_balance_pkg.get_value(
696: bal_db_item('SIT_SUBJ_WHABLE_PER_JD_GRE_QTD') , p_assignment_id,
697: least(p_period_end, p_effective_end_date)) <> 0 );
698: END IF ;
699: END IF ;

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

1383: --
1384: -- Set up TAX_UNIT_ID context if appropriate.
1385: --
1386: if l_tax_unit_context then
1387: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
1388: end if;
1389: --
1390: -- Set up JURISDICTION_CODE context if appropriate.
1391: --

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

1389: --
1390: -- Set up JURISDICTION_CODE context if appropriate.
1391: --
1392: if l_jurisdiction_context then
1393: pay_balance_pkg.set_context('JURISDICTION_CODE',l_jurisdiction_code);
1394: end if;
1395: --
1396: --
1397: -- Check the balance.

Line 1424: l_value := pay_balance_pkg.get_value

1420: l_1099R_ind := null;
1421: end;
1422: end if;
1423: if (nvl(l_1099R_ind, 'N') <> 'Y') and ((l_tax_unit_id = l_transfer_gre_id) or (l_transfer_gre_id is null)) then
1424: l_value := pay_balance_pkg.get_value
1425: (l_defined_balance_id,
1426: l_assignment_id,
1427: least(l_period_end,l_effective_end_date));
1428: --4310812

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

1426: l_assignment_id,
1427: least(l_period_end,l_effective_end_date));
1428: --4310812
1429: If l_state = 'ME' Then
1430: l_value_sit := pay_balance_pkg.get_value(bal_db_item('SIT_SUBJ_WHABLE_PER_JD_GRE_QTD') ,
1431: l_assignment_id,
1432: least(l_period_end, l_effective_end_date)) ;
1433:
1434: If nvl(l_value,0) <> 0 and nvl(l_value_sit,0) <> 0 Then

Line 1450: l_value := pay_balance_pkg.get_value

1446: if instr(to_char(l_quarter_end,'MM'), '12') <> 0 then /*Check for Last Quarter*/
1447:
1448: hr_utility.trace('Last Quarter.Check the values for SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD');
1449:
1450: l_value := pay_balance_pkg.get_value
1451: (bal_db_item('SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD'),
1452: l_assignment_id,
1453: least(l_period_end,l_effective_end_date));
1454:

Line 1469: l_value := pay_balance_pkg.get_value

1465: l_value := 0;
1466:
1467: ELSE
1468:
1469: l_value := pay_balance_pkg.get_value
1470: (bal_db_item('SUI_ER_SUBJ_WHABLE_PER_JD_GRE_QTD'),
1471: l_assignment_id,
1472: least(l_period_end,l_effective_end_date));
1473:

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

1643: /* Added the g_report_cat variable on 10-FEB-2000 by Ashu Gupta (ashgupta).
1644: This variable will be used in archive_data procedure to decide the report
1645: category */
1646:
1647: pay_balance_pkg.set_context ('JURISDICTION_CODE',jurisdiction_code);
1648: END IF;
1649: /* Bug 773937 */
1650: hr_utility.set_location ('archinit getting min chunk number',10);
1651: open c_get_min_chunk;

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

2464: hr_utility.trace('Adjusting the Ohio Taxable');
2465: l_user_entity_id :=get_user_entity_id('A_SUI_OH_ER_ADJ_TAXABLE_ASG_GRE_QTD');
2466: l_oh_jurisdiction_code := '36-000-0000';
2467:
2468: pay_balance_pkg.set_context('TAX_UNIT_ID',taxunitid);
2469: pay_balance_pkg.set_context('JURISDICTION_CODE',l_oh_jurisdiction_code);
2470:
2471: SELECT least(max(effective_end_date),p_effective_date)
2472: INTO l_effective_end_date

Line 2469: pay_balance_pkg.set_context('JURISDICTION_CODE',l_oh_jurisdiction_code);

2465: l_user_entity_id :=get_user_entity_id('A_SUI_OH_ER_ADJ_TAXABLE_ASG_GRE_QTD');
2466: l_oh_jurisdiction_code := '36-000-0000';
2467:
2468: pay_balance_pkg.set_context('TAX_UNIT_ID',taxunitid);
2469: pay_balance_pkg.set_context('JURISDICTION_CODE',l_oh_jurisdiction_code);
2470:
2471: SELECT least(max(effective_end_date),p_effective_date)
2472: INTO l_effective_end_date
2473: FROM per_all_assignments_f

Line 2505: l_sui_oh_taxable_qtd := pay_balance_pkg.get_value( l_def_bal_id,

2501:
2502: if l_dimension_name = 'Person in JD within GRE Quarter to Date' then
2503:
2504:
2505: l_sui_oh_taxable_qtd := pay_balance_pkg.get_value( l_def_bal_id,
2506: asgid,
2507: l_effective_date);
2508:
2509: hr_utility.trace('l_sui_oh_taxable_qtd '||l_sui_oh_taxable_qtd);

Line 2513: l_sui_total_taxable_qtd :=pay_balance_pkg.get_value( l_def_bal_id,

2509: hr_utility.trace('l_sui_oh_taxable_qtd '||l_sui_oh_taxable_qtd);
2510: else
2511:
2512:
2513: l_sui_total_taxable_qtd :=pay_balance_pkg.get_value( l_def_bal_id,
2514: asgid,
2515: l_effective_date);
2516: hr_utility.trace('l_sui_total_taxable_qtd '||l_sui_total_taxable_qtd);
2517:

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

2592: hr_utility.trace('l_sui_ar_tax_user_ent_id: ' || TO_CHAR(l_sui_ar_tax_user_ent_id));
2593: hr_utility.trace('l_sui_ar_oos_rpt_user_ent_id: ' || TO_CHAR(l_sui_ar_oos_rpt_user_ent_id));
2594: hr_utility.trace('l_sui_ar_oos_stcd_user_ent_id: ' || TO_CHAR(l_sui_ar_oos_stcd_user_ent_id));
2595:
2596: pay_balance_pkg.set_context('TAX_UNIT_ID',taxunitid);
2597: pay_balance_pkg.set_context('JURISDICTION_CODE',l_ar_jurisdiction_code);
2598:
2599: /* This query is to get the Last Effective Day of Employee in Arkansas in the Quarter */
2600: /* Modified for Bug#14371049 */

Line 2597: pay_balance_pkg.set_context('JURISDICTION_CODE',l_ar_jurisdiction_code);

2593: hr_utility.trace('l_sui_ar_oos_rpt_user_ent_id: ' || TO_CHAR(l_sui_ar_oos_rpt_user_ent_id));
2594: hr_utility.trace('l_sui_ar_oos_stcd_user_ent_id: ' || TO_CHAR(l_sui_ar_oos_stcd_user_ent_id));
2595:
2596: pay_balance_pkg.set_context('TAX_UNIT_ID',taxunitid);
2597: pay_balance_pkg.set_context('JURISDICTION_CODE',l_ar_jurisdiction_code);
2598:
2599: /* This query is to get the Last Effective Day of Employee in Arkansas in the Quarter */
2600: /* Modified for Bug#14371049 */
2601: /* Modified for Bug#16236978 */

Line 2664: l_sui_ar_subj_whable_qtd := pay_balance_pkg.get_value(l_def_bal_id,

2660: IF l_dimension_name = 'Person in JD within GRE Quarter to Date' THEN
2661:
2662: IF l_balance_name = 'SUI ER Subj Whable' THEN
2663: /* AR Subj Whable Wages till Last Effective Date of Employee in AR in Quarter */
2664: l_sui_ar_subj_whable_qtd := pay_balance_pkg.get_value(l_def_bal_id,
2665: asgid,
2666: l_effective_date);
2667:
2668: hr_utility.trace('l_sui_ar_subj_whable_qtd: '|| TO_CHAR(l_sui_ar_subj_whable_qtd));

Line 2672: l_sui_ar_pre_tax_redn_qtd := pay_balance_pkg.get_value(l_def_bal_id,

2668: hr_utility.trace('l_sui_ar_subj_whable_qtd: '|| TO_CHAR(l_sui_ar_subj_whable_qtd));
2669:
2670: ELSIF l_balance_name = 'SUI ER Pre Tax Redns' THEN
2671: /* AR Pre Tax Redn Wages till Last Effective Date of Employee in AR in Quarter */
2672: l_sui_ar_pre_tax_redn_qtd := pay_balance_pkg.get_value(l_def_bal_id,
2673: asgid,
2674: l_effective_date);
2675:
2676: hr_utility.trace('l_sui_ar_pre_tax_redn_qtd: '|| TO_CHAR(l_sui_ar_pre_tax_redn_qtd));

Line 2683: l_sui_ar_taxable_ytd := pay_balance_pkg.get_value(l_def_bal_id,

2679: ELSIF l_dimension_name = 'Person in JD within GRE Year to Date' THEN
2680:
2681: IF l_balance_name = 'SUI ER Taxable' THEN
2682: /* AR Taxable Wages till Last Effective Date of Employee in AR in Year */
2683: l_sui_ar_taxable_ytd := pay_balance_pkg.get_value(l_def_bal_id,
2684: asgid,
2685: l_effective_date);
2686:
2687: hr_utility.trace('l_sui_ar_taxable_ytd: '|| TO_CHAR(l_sui_ar_taxable_ytd));

Line 2691: l_sui_ar_subj_whable_ytd := pay_balance_pkg.get_value(l_def_bal_id,

2687: hr_utility.trace('l_sui_ar_taxable_ytd: '|| TO_CHAR(l_sui_ar_taxable_ytd));
2688:
2689: ELSIF l_balance_name = 'SUI ER Subj Whable' THEN
2690: /* AR Subj Whable Wages till Last Effective Date of Employee in AR in Year */
2691: l_sui_ar_subj_whable_ytd := pay_balance_pkg.get_value(l_def_bal_id,
2692: asgid,
2693: l_effective_date);
2694:
2695: hr_utility.trace('l_sui_ar_subj_whable_ytd: '|| TO_CHAR(l_sui_ar_subj_whable_ytd));

Line 2699: l_sui_ar_pre_tax_redn_ytd := pay_balance_pkg.get_value(l_def_bal_id,

2695: hr_utility.trace('l_sui_ar_subj_whable_ytd: '|| TO_CHAR(l_sui_ar_subj_whable_ytd));
2696:
2697: ELSIF l_balance_name = 'SUI ER Pre Tax Redns' THEN
2698: /* AR Pre Tax Redn Wages till Last Effective Date of Employee in AR in Year */
2699: l_sui_ar_pre_tax_redn_ytd := pay_balance_pkg.get_value(l_def_bal_id,
2700: asgid,
2701: l_effective_date);
2702:
2703: hr_utility.trace('l_sui_ar_pre_tax_redn_ytd: '|| TO_CHAR(l_sui_ar_pre_tax_redn_ytd));

Line 2709: l_sui_ar_total_taxable_ytd := pay_balance_pkg.get_value(l_def_bal_id,

2705:
2706: ELSIF l_dimension_name = 'Person within Government Reporting Entity Year to Date' THEN
2707:
2708: /* Total Wages till Last Effective Date of Employee in AR in Year */
2709: l_sui_ar_total_taxable_ytd := pay_balance_pkg.get_value(l_def_bal_id,
2710: asgid,
2711: l_effective_date);
2712:
2713: hr_utility.trace('l_sui_ar_total_taxable_ytd '|| TO_CHAR(l_sui_ar_total_taxable_ytd));

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

2894: l_user_entity_id :=get_user_entity_id('SUI_ER_FL_ADJ_TAXABLE_PER_JD_GRE_QTD');
2895:
2896: fl_jurisdiction_code := '10-000-0000';
2897:
2898: pay_balance_pkg.set_context('TAX_UNIT_ID',taxunitid);
2899:
2900: pay_balance_pkg.set_context('JURISDICTION_CODE',fl_jurisdiction_code);
2901:
2902: /* Modified for Bug#9561700*/

Line 2900: pay_balance_pkg.set_context('JURISDICTION_CODE',fl_jurisdiction_code);

2896: fl_jurisdiction_code := '10-000-0000';
2897:
2898: pay_balance_pkg.set_context('TAX_UNIT_ID',taxunitid);
2899:
2900: pay_balance_pkg.set_context('JURISDICTION_CODE',fl_jurisdiction_code);
2901:
2902: /* Modified for Bug#9561700*/
2903: /* First find out if the Assignment record is ending in between the Quarter.If
2904: it is not, then call the balance procedure with Quarter End Date.If the Assignment

Line 2945: l_sui_fl_taxable_qtd := pay_balance_pkg.get_value( l_def_bal_id,

2941: if l_dimension_name = 'Person in JD within GRE Quarter to Date' then
2942:
2943:
2944:
2945: l_sui_fl_taxable_qtd := pay_balance_pkg.get_value( l_def_bal_id,
2946: asgid,
2947: l_effective_date);
2948:
2949: hr_utility.trace('l_sui_fl_taxable_qtd'||l_sui_fl_taxable_qtd);

Line 2955: l_sui_fl_taxable_ytd := pay_balance_pkg.get_value( l_def_bal_id,

2951:
2952: elsif l_dimension_name = 'Person in JD within GRE Year to Date' then
2953:
2954:
2955: l_sui_fl_taxable_ytd := pay_balance_pkg.get_value( l_def_bal_id,
2956: asgid,
2957: l_effective_date);
2958:
2959: hr_utility.trace('l_sui_fl_taxable_ytd'||l_sui_fl_taxable_ytd);

Line 2964: l_sui_taxable_ytd := pay_balance_pkg.get_value( l_def_bal_id,

2960:
2961:
2962: else
2963:
2964: l_sui_taxable_ytd := pay_balance_pkg.get_value( l_def_bal_id,
2965: asgid,
2966: l_effective_date);
2967:
2968: hr_utility.trace('l_sui_taxable_ytd'||l_sui_taxable_ytd);

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

3200: /* End of Bug 773937 */
3201:
3202: /* Setup contexts */
3203:
3204: pay_balance_pkg.set_context ('ASSIGNMENT_ID', asgid);
3205: pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned));
3206: /* pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned,'DD-MON-YYYY')); date format not required */
3207: pay_balance_pkg.set_context ('TAX_UNIT_ID', taxunitid);
3208:

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

3201:
3202: /* Setup contexts */
3203:
3204: pay_balance_pkg.set_context ('ASSIGNMENT_ID', asgid);
3205: pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned));
3206: /* pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned,'DD-MON-YYYY')); date format not required */
3207: pay_balance_pkg.set_context ('TAX_UNIT_ID', taxunitid);
3208:
3209: /* Get the year begin and year end dates */

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

3202: /* Setup contexts */
3203:
3204: pay_balance_pkg.set_context ('ASSIGNMENT_ID', asgid);
3205: pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned));
3206: /* pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned,'DD-MON-YYYY')); date format not required */
3207: pay_balance_pkg.set_context ('TAX_UNIT_ID', taxunitid);
3208:
3209: /* Get the year begin and year end dates */
3210:

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

3203:
3204: pay_balance_pkg.set_context ('ASSIGNMENT_ID', asgid);
3205: pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned));
3206: /* pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned,'DD-MON-YYYY')); date format not required */
3207: pay_balance_pkg.set_context ('TAX_UNIT_ID', taxunitid);
3208:
3209: /* Get the year begin and year end dates */
3210:
3211: l_year_start := trunc(p_effective_date, 'Y');

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

3294: set serial_number = 1
3295: where paa.assignment_action_id = p_assactid;
3296: END IF;
3297: END IF;
3298: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',aaid);
3299: pay_archive.balance_aa := aaid;
3300:
3301: exception
3302: when others then