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.HR_JPBAL dependencies on PAY_ASSIGNMENT_ACTIONS

Line 391: FROM pay_assignment_actions paa,

387: cursor get_corr_type (c_assignment_action_id IN NUMBER)
388: is
389: SELECT /*+ ORDERED */
390: paa.assignment_id
391: FROM pay_assignment_actions paa,
392: pay_payroll_actions ppa
393: WHERE paa.assignment_action_id = c_assignment_action_id
394: AND ppa.payroll_action_id = paa.payroll_action_id
395: AND ppa.action_type in ('R', 'Q', 'I', 'V', 'B');

Line 427: FROM pay_assignment_actions paa,

423: is
424: SELECT /*+ ORDERED */
425: TO_NUMBER(substr(max(lpad(paa.action_sequence,15,'0')||
426: paa.assignment_action_id),16))
427: FROM pay_assignment_actions paa,
428: pay_payroll_actions ppa
429: WHERE paa.assignment_id = c_assignment_id
430: AND ppa.payroll_action_id = paa.payroll_action_id
431: AND ppa.effective_date <= c_effective_date

Line 478: pay_assignment_actions BAL_ASSACT

474: BACT.effective_date,
475: BACT.date_earned,
476: BACT.business_group_id
477: FROM pay_payroll_actions BACT,
478: pay_assignment_actions BAL_ASSACT
479: WHERE BAL_ASSACT.assignment_action_id = p_assignment_action_id
480: AND BACT.payroll_action_id = BAL_ASSACT.payroll_action_id;
481: --
482: cursor balance_dimension

Line 623: FROM pay_assignment_actions paa,

619: CURSOR csr_assact
620: IS
621: SELECT /*+ ORDERED */
622: pdb.defined_balance_id
623: FROM pay_assignment_actions paa,
624: pay_payroll_actions ppa,
625: ff_database_items ffd,
626: ff_user_entities ffu,
627: hr_organization_information hoi,

Line 908: pay_assignment_actions ASSACT

904: is
905: SELECT TO_NUMBER(substr(max(lpad(ASSACT.action_sequence,15,'0')||
906: ASSACT.assignment_action_id),16))
907: FROM pay_payroll_actions PACT,
908: pay_assignment_actions ASSACT
909: WHERE ASSACT.assignment_id = c_assignment_id
910: AND PACT.payroll_action_id = ASSACT.payroll_action_id
911: AND PACT.date_earned <= c_effective_date
912: AND PACT.action_type in ('R', 'Q', 'I', 'V', 'B');

Line 919: pay_assignment_actions paa

915: is
916: SELECT ppa.effective_date effect_date,
917: ppa.date_earned earned_date
918: FROM pay_payroll_actions ppa,
919: pay_assignment_actions paa
920: WHERE paa.assignment_action_id = c_assignment_action_id
921: AND paa.payroll_action_id = ppa.payroll_action_id;
922: --
923: l_last_date last_date%ROWTYPE;

Line 1058: FROM pay_assignment_actions paa,

1054: cursor expired_time_period(c_assignment_action_id IN NUMBER)
1055: is
1056: SELECT /*+ ORDERED */
1057: ptp.end_date
1058: FROM pay_assignment_actions paa,
1059: pay_payroll_actions ppa,
1060: per_time_periods ptp
1061: WHERE paa.assignment_action_id = c_assignment_action_id
1062: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1207: FROM pay_assignment_actions paa,

1203: cursor expired_time_period(c_assignment_action_id IN NUMBER)
1204: is
1205: SELECT /*+ ORDERED */
1206: ptp.end_date
1207: FROM pay_assignment_actions paa,
1208: pay_payroll_actions ppa,
1209: per_time_periods ptp
1210: WHERE paa.assignment_action_id = c_assignment_action_id
1211: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1357: FROM pay_assignment_actions paa,

1353: cursor last_start_date(c_assignment_action_id IN NUMBER)
1354: is
1355: SELECT /*+ ORDERED */
1356: trunc(ppa.effective_date,'MM')
1357: FROM pay_assignment_actions paa,
1358: pay_payroll_actions ppa
1359: WHERE paa.assignment_action_id = c_assignment_action_id
1360: AND ppa.payroll_action_id = paa.payroll_action_id;
1361: --

Line 1501: FROM pay_assignment_actions paa,

1497: cursor last_start_date(c_assignment_action_id IN NUMBER)
1498: is
1499: SELECT /*+ ORDERED */
1500: trunc(ppa.effective_date,'YYYY')
1501: FROM pay_assignment_actions paa,
1502: pay_payroll_actions ppa
1503: WHERE paa.assignment_action_id = c_assignment_action_id
1504: AND ppa.payroll_action_id = paa.payroll_action_id;
1505: --

Line 1645: FROM pay_assignment_actions ASSACT,

1641: SELECT /*+ ORDERED */
1642: add_months(nvl(FND_DATE.CANONICAL_TO_DATE(HROG.org_information11),trunc(PACT.date_earned,'YYYY')),
1643: floor(months_between(PACT.date_earned,nvl(FND_DATE.CANONICAL_TO_DATE(HROG.org_information11),
1644: trunc(PACT.date_earned,'YYYY')))/12)*12) last_start_date
1645: FROM pay_assignment_actions ASSACT,
1646: pay_payroll_actions PACT,
1647: hr_organization_information HROG
1648: WHERE ASSACT.assignment_action_id = c_assignment_action_id
1649: AND PACT.payroll_action_id = ASSACT.payroll_action_id

Line 1659: FROM pay_assignment_actions ASSACT,

1655: is
1656: SELECT /*+ ORDERED */
1657: TO_NUMBER(substr(max(lpad(ASSACT.action_sequence,15,'0')||
1658: ASSACT.assignment_action_id),16))
1659: FROM pay_assignment_actions ASSACT,
1660: pay_payroll_actions PACT
1661: WHERE ASSACT.assignment_id = c_assignment_id
1662: AND PACT.payroll_action_id = ASSACT.payroll_action_id
1663: AND PACT.date_earned <= c_effective_date

Line 1816: FROM pay_assignment_actions ASSACT,

1812: SELECT /*+ ORDERED */
1813: add_months(nvl(FND_DATE.CANONICAL_TO_DATE(HROG.org_information11),trunc(PACT.effective_date,'YYYY')),
1814: floor(months_between(PACT.effective_date,nvl(FND_DATE.CANONICAL_TO_DATE(HROG.org_information11),
1815: trunc(PACT.effective_date,'YYYY')))/12)*12) last_start_date
1816: FROM pay_assignment_actions ASSACT,
1817: pay_payroll_actions PACT,
1818: hr_organization_information HROG
1819: WHERE ASSACT.assignment_action_id = c_assignment_action_id
1820: AND PACT.payroll_action_id = ASSACT.payroll_action_id

Line 1831: FROM pay_assignment_actions ASSACT,

1827: is
1828: SELECT /*+ ORDERED */
1829: TO_NUMBER(substr(max(lpad(ASSACT.action_sequence,15,'0')||
1830: ASSACT.assignment_action_id),16))
1831: FROM pay_assignment_actions ASSACT,
1832: pay_payroll_actions PACT
1833: WHERE ASSACT.assignment_id = c_assignment_id
1834: AND PACT.payroll_action_id = ASSACT.payroll_action_id
1835: AND PACT.effective_date <= c_effective_date

Line 1972: from pay_assignment_actions paa,

1968: cursor last_start_date(c_assignment_action_id in number)
1969: is
1970: select /*+ ORDERED */
1971: add_months(trunc(add_months(ppa.effective_date,9),'YYYY'),-9)
1972: from pay_assignment_actions paa,
1973: pay_payroll_actions ppa
1974: where paa.assignment_action_id = c_assignment_action_id
1975: and ppa.payroll_action_id = paa.payroll_action_id;
1976: --

Line 2121: FROM pay_assignment_actions paa,

2117: cursor last_start_date(c_assignment_action_id IN NUMBER)
2118: is
2119: SELECT /*+ ORDERED */
2120: add_months(trunc(add_months(ppa.effective_date,5),'YYYY'),-5)
2121: FROM pay_assignment_actions paa,
2122: pay_payroll_actions ppa
2123: WHERE paa.assignment_action_id = c_assignment_action_id
2124: AND ppa.payroll_action_id = paa.payroll_action_id;
2125: --

Line 2261: FROM pay_assignment_actions paa,

2257: cursor last_start_date(c_assignment_action_id IN NUMBER)
2258: is
2259: SELECT /*+ ORDERED */
2260: add_months(trunc(add_months(ppa.effective_date,6),'YYYY'),-6)
2261: FROM pay_assignment_actions paa,
2262: pay_payroll_actions ppa
2263: WHERE paa.assignment_action_id = c_assignment_action_id
2264: AND paa.payroll_action_id = ppa.payroll_action_id;
2265: --

Line 2527: FROM pay_assignment_actions paa,

2523: cursor expired_time_period(c_assignment_action_id IN NUMBER)
2524: is
2525: SELECT /*+ ORDERED */
2526: ptp.end_date
2527: FROM pay_assignment_actions paa,
2528: pay_payroll_actions ppa,
2529: per_time_periods ptp
2530: WHERE paa.assignment_action_id = c_assignment_action_id
2531: AND ppa.payroll_action_id = paa.payroll_action_id

Line 2673: FROM pay_assignment_actions paa,

2669: cursor expired_time_period(c_assignment_action_id IN NUMBER)
2670: is
2671: SELECT /*+ ORDERED */
2672: ptp.end_date
2673: FROM pay_assignment_actions paa,
2674: pay_payroll_actions ppa,
2675: per_time_periods ptp
2676: WHERE paa.assignment_action_id = c_assignment_action_id
2677: AND ppa.payroll_action_id = paa.payroll_action_id