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_CA_GROUP_LEVEL_BAL_PKG dependencies on PAY_RUN_BALANCES

Line 582: -- Uses PAY_RUN_BALANCES tables for all cursors in this function.

578: -- Description: This function calculates the balance value for all PYDATE level
579: -- balance wich have at least one parameter which is not a context.
580: -- This function is split into two parts: when the pay basis type
581: -- NULL and when it has a value.
582: -- Uses PAY_RUN_BALANCES tables for all cursors in this function.
583: -------------------------------------------------------------------------------
584: FUNCTION get_grp_pydate_with_aa_rb
585: (p_lb_dimension VARCHAR2,
586: p_balance_name VARCHAR2,

Line 605: -- NEW EBRA CURSOR csr_get_asg_gre_add definition with pay_run_balances

601: * These are for the cases where at least one of the additional parameter is
602: * NULL, (ie. l,ocation_id, organization_id, payroll_id, pay_basis_type)
603: */
604:
605: -- NEW EBRA CURSOR csr_get_asg_gre_add definition with pay_run_balances
606: -- validation.
607: CURSOR csr_get_asg_gre_add_rb(p_org_id NUMBER,
608: p_loc_id NUMBER,
609: p_pay_id NUMBER,

Line 616: FROM pay_run_balances prb,

612: p_start_date DATE,
613: p_end_date DATE,
614: p_def_bal_id NUMBER) IS
615: SELECT DISTINCT prb.assignment_action_id
616: FROM pay_run_balances prb,
617: per_all_assignments_f asg
618: WHERE asg.organization_id = NVL(p_org_id, asg.organization_id)
619: AND asg.location_id = NVL(p_loc_id, asg.location_id)
620: AND asg.payroll_id = NVL(p_pay_id, asg.payroll_id)

Line 641: -- pay_run_balances validation.

637: AND p_end_date;
638:
639:
640: -- NEW EBRA CURSOR csr_get_asg_src_add definition with
641: -- pay_run_balances validation.
642: CURSOR csr_get_asg_src_add_rb(p_org_id NUMBER,
643: p_loc_id NUMBER,
644: p_pay_id NUMBER,
645: p_basis_type VARCHAR2,

Line 652: pay_run_balances prb

648: p_end_date DATE,
649: p_def_bal_id NUMBER) IS
650: SELECT DISTINCT prb.assignment_action_id
651: FROM per_all_assignments_f asg,
652: pay_run_balances prb
653: WHERE prb.source_id = p_src_id
654: AND prb.effective_date BETWEEN p_start_date
655: AND p_end_date
656: AND prb.assignment_id = asg.assignment_id

Line 683: -- pay_run_balances validation

679: * NULL, (ie. l,ocation_id, organization_id, payroll_id, pay_basis_type)
680: */
681:
682: -- NEW EBRA CURSOR csr_get_asg_jd_gre_add definition with
683: -- pay_run_balances validation
684: CURSOR csr_get_asg_jd_gre_add_rb(p_org_id NUMBER,
685: p_loc_id NUMBER,
686: p_pay_id NUMBER,
687: p_basis_type VARCHAR2,

Line 695: pay_run_balances prb

691: p_end_date DATE,
692: p_def_bal_id NUMBER) IS
693: SELECT DISTINCT prb.assignment_action_id
694: FROM per_all_assignments_f asg,
695: pay_run_balances prb
696: WHERE prb.jurisdiction_code = p_jd
697: AND prb.tax_unit_id = p_gre_id
698: AND prb.defined_balance_id = p_def_bal_id
699: AND prb.effective_date BETWEEN p_start_date

Line 1463: -- Uses pay_run_balances validation in all cursor definitions (EBRA)

1459: -- Return: NUMBER - The value of the group level balance
1460: --
1461: -- Description: This function calculates the balance value given an assignment
1462: -- id and date. If the latest balances exist they will be utilised.
1463: -- Uses pay_run_balances validation in all cursor definitions (EBRA)
1464: -------------------------------------------------------------------------------
1465: FUNCTION get_grp_non_pydate_with_asg_rb
1466: (p_assignment_id NUMBER,
1467: p_time_dimension VARCHAR2,

Line 1507: -- pay_run_balances validation.

1503: * organization_id, payroll_id, pay_basis_type are NULL
1504: */
1505:
1506: -- NEW EBRA CURSOR csr_get_asg_gre definition with
1507: -- pay_run_balances validation.
1508: CURSOR csr_get_asg_gre_rb(p_gre_id NUMBER,
1509: p_start_date DATE,
1510: p_end_date DATE,
1511: p_def_bal_id NUMBER) IS

Line 1515: FROM pay_run_balances prb

1511: p_def_bal_id NUMBER) IS
1512: SELECT DISTINCT(asg.assignment_id) assignment_id
1513: FROM per_all_assignments_f asg
1514: WHERE EXISTS (SELECT 'X'
1515: FROM pay_run_balances prb
1516: WHERE prb.assignment_id = asg.assignment_id
1517: AND prb.tax_unit_id = p_gre_id
1518: AND prb.defined_balance_id = p_def_bal_id
1519: AND prb.effective_date BETWEEN p_start_date

Line 1524: -- pay_run_balances validation.

1520: AND p_end_date);
1521:
1522:
1523: -- NEW EBRA CURSOR csr_get_asg_src definition with
1524: -- pay_run_balances validation.
1525: CURSOR csr_get_asg_src_rb(p_src_id NUMBER,
1526: p_start_date DATE,
1527: p_end_date DATE
1528: ) IS

Line 1530: FROM pay_run_balances prb

1526: p_start_date DATE,
1527: p_end_date DATE
1528: ) IS
1529: SELECT DISTINCT(prb.assignment_id) assignment_id
1530: FROM pay_run_balances prb
1531: WHERE prb.source_id = p_src_id
1532: AND prb.effective_date BETWEEN p_start_date AND p_end_date;
1533:
1534:

Line 1542: -- pay_run_balances validation.

1538: * These are for the cases where all the additional parameter ie. location_id,
1539: * organization_id, payroll_id, pay_basis_type are NULL
1540: */
1541: -- NEW EBRA CURSOR csr_get_asg_jd_gre definition with
1542: -- pay_run_balances validation.
1543: CURSOR csr_get_asg_jd_gre_rb(p_gre_id NUMBER,
1544: p_jd VARCHAR2,
1545: p_start_date DATE,
1546: p_end_date DATE,

Line 1549: FROM pay_run_balances prb

1545: p_start_date DATE,
1546: p_end_date DATE,
1547: p_def_bal_id NUMBER) IS
1548: SELECT DISTINCT(prb.assignment_id) assignment_id
1549: FROM pay_run_balances prb
1550: WHERE prb.tax_unit_id = p_gre_id
1551: AND prb.jurisdiction_code = p_jd
1552: AND prb.defined_balance_id = p_def_bal_id
1553: AND prb.effective_date BETWEEN p_start_date AND p_end_date;

Line 1589: -- pay_run_balances validation.

1585: * NULL, (ie. l,ocation_id, organization_id, payroll_id, pay_basis_type)
1586: */
1587:
1588: -- NEW CURSOR csr_get_asg_gre_add definition with
1589: -- pay_run_balances validation.
1590: CURSOR csr_get_asg_gre_add_rb(p_org_id NUMBER,
1591: p_loc_id NUMBER,
1592: p_pay_id NUMBER,
1593: p_basis_type VARCHAR2,

Line 1616: FROM pay_run_balances prb

1612: WHERE pyb.pay_basis IN
1613: ('ANNUAL','MONTHLY','PERIOD')))
1614: OR (p_basis_type IS NULL))
1615: AND EXISTS (SELECT 'X'
1616: FROM pay_run_balances prb
1617: WHERE prb.assignment_id = asg.assignment_id
1618: AND prb.tax_unit_id = p_gre_id
1619: AND prb.defined_balance_id = p_def_bal_id
1620: AND prb.effective_date BETWEEN p_start_date

Line 1625: -- pay_run_balances validation

1621: AND p_end_date);
1622:
1623:
1624: -- NEW EBRA CURSOR csr_get_asg_src_add definition with
1625: -- pay_run_balances validation
1626: CURSOR csr_get_asg_src_add_rb(p_org_id NUMBER,
1627: p_loc_id NUMBER,
1628: p_pay_id NUMBER,
1629: p_basis_type VARCHAR2,

Line 1637: FROM pay_run_balances prb

1633: p_def_bal_id NUMBER) IS
1634: SELECT DISTINCT(asg.assignment_id) assignment_id
1635: FROM per_all_assignments_f asg
1636: WHERE EXISTS (SELECT 'X'
1637: FROM pay_run_balances prb
1638: WHERE asg.assignment_id = prb.assignment_id
1639: AND prb.source_id = p_src_id
1640: AND prb.defined_balance_id = p_def_bal_id
1641: AND prb.effective_date BETWEEN p_start_date

Line 1669: -- pay_run_balances validation.

1665: * NULL, (ie. l,ocation_id, organization_id, payroll_id, pay_basis_type)
1666: */
1667:
1668: -- NEW EBRA CURSOR csr_get_asg_jd_gre_add definition with
1669: -- pay_run_balances validation.
1670: CURSOR csr_get_asg_jd_gre_add_rb(p_org_id NUMBER,
1671: p_loc_id NUMBER,
1672: p_pay_id NUMBER,
1673: p_basis_type VARCHAR2,

Line 1682: FROM pay_run_balances prb

1678: p_def_bal_id NUMBER) IS
1679: SELECT DISTINCT(asg.assignment_id) assignment_id
1680: FROM per_all_assignments_f asg
1681: WHERE EXISTS (SELECT 'X'
1682: FROM pay_run_balances prb
1683: WHERE prb.assignment_id = asg.assignment_id
1684: AND prb.tax_unit_id = p_gre_id
1685: AND prb.jurisdiction_code = p_jd
1686: AND prb.defined_balance_id = p_def_bal_id

Line 2121: from pay_run_balances prb,per_all_assignments_f paf

2117: p_end_date DATE,
2118: p_gre NUMBER,
2119: cp_def_bal_id NUMBER) IS
2120: select prb.assignment_id,paf.business_group_id
2121: from pay_run_balances prb,per_all_assignments_f paf
2122: where prb.defined_balance_id = cp_def_bal_id
2123: and prb.tax_unit_id = p_gre
2124: and prb.effective_date between p_start_date AND p_end_date
2125: and prb.assignment_id = paf.assignment_id

Line 2578: -- pay_run_balances validation to check for valid assignments

2574: -- Business Payroll Survey
2575: -- Gross to Net
2576:
2577: -- This function has been modified with
2578: -- pay_run_balances validation to check for valid assignments
2579: -- or assignment_actions. If p_flag is 'Y' this routine will
2580: -- use EBRA validation to avoid unnecessary balance calls for
2581: -- assignment_actions or assignments, if p_flas is 'N' it uses
2582: -- old routine ca_group_level_balance .

Line 2615: pay_run_balances prb

2611: cp_def_bal_id NUMBER) IS
2612: SELECT asg.assignment_id,
2613: asg.business_group_id
2614: FROM per_all_assignments_f asg,
2615: pay_run_balances prb
2616: WHERE prb.defined_balance_id = cp_def_bal_id
2617: and prb.effective_date between p_start_date AND p_end_date
2618: and prb.tax_unit_id = p_gre
2619: and prb.assignment_id = asg.assignment_id

Line 2658: from pay_run_balances prb,per_all_assignments_f paf

2654: p_end_date DATE,
2655: p_gre NUMBER,
2656: cp_def_bal_id NUMBER) IS
2657: select prb.assignment_id,paf.business_group_id
2658: from pay_run_balances prb,per_all_assignments_f paf
2659: where prb.defined_balance_id = cp_def_bal_id
2660: and prb.tax_unit_id = p_gre
2661: and prb.effective_date between p_start_date AND p_end_date
2662: and prb.assignment_id = paf.assignment_id

Line 2681: FROM pay_run_balances prb,

2677: p_end_date DATE,
2678: p_src NUMBER,
2679: cp_def_bal_id NUMBER) IS
2680: SELECT prb.assignment_id, asg.business_group_id
2681: FROM pay_run_balances prb,
2682: per_all_assignments_f asg
2683: WHERE prb.defined_balance_id = cp_def_bal_id
2684: and asg.assignment_id = prb.assignment_id
2685: and prb.source_id = TO_CHAR(p_src)

Line 2918: def_bal_id to get the assignment_id from pay_run_balances.

2914:
2915: l_dim_str1 := 'RPT_UNIT_';
2916:
2917: /* Added code to get the def_bal_id so that we can pass the
2918: def_bal_id to get the assignment_id from pay_run_balances.
2919: part of fix for bug#3637426
2920: */
2921: IF l_balance_name is not null THEN
2922: ln_new_defbal_id := get_defined_balance(l_balance_name,