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 928: pay_assignment_actions ASSACT

924: is
925: SELECT TO_NUMBER(substr(max(lpad(ASSACT.action_sequence,15,'0')||
926: ASSACT.assignment_action_id),16))
927: FROM pay_payroll_actions PACT,
928: pay_assignment_actions ASSACT
929: WHERE ASSACT.assignment_id = c_assignment_id
930: AND PACT.payroll_action_id = ASSACT.payroll_action_id
931: AND PACT.date_earned <= c_effective_date
932: AND PACT.action_type in ('R', 'Q', 'I', 'V', 'B');

Line 939: pay_assignment_actions paa

935: is
936: SELECT ppa.effective_date effect_date,
937: ppa.date_earned earned_date
938: FROM pay_payroll_actions ppa,
939: pay_assignment_actions paa
940: WHERE paa.assignment_action_id = c_assignment_action_id
941: AND paa.payroll_action_id = ppa.payroll_action_id;
942: --
943: l_last_date last_date%ROWTYPE;

Line 1078: FROM pay_assignment_actions paa,

1074: cursor expired_time_period(c_assignment_action_id IN NUMBER)
1075: is
1076: SELECT /*+ ORDERED */
1077: ptp.end_date
1078: FROM pay_assignment_actions paa,
1079: pay_payroll_actions ppa,
1080: per_time_periods ptp
1081: WHERE paa.assignment_action_id = c_assignment_action_id
1082: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1227: FROM pay_assignment_actions paa,

1223: cursor expired_time_period(c_assignment_action_id IN NUMBER)
1224: is
1225: SELECT /*+ ORDERED */
1226: ptp.end_date
1227: FROM pay_assignment_actions paa,
1228: pay_payroll_actions ppa,
1229: per_time_periods ptp
1230: WHERE paa.assignment_action_id = c_assignment_action_id
1231: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1377: FROM pay_assignment_actions paa,

1373: cursor last_start_date(c_assignment_action_id IN NUMBER)
1374: is
1375: SELECT /*+ ORDERED */
1376: trunc(ppa.effective_date,'MM')
1377: FROM pay_assignment_actions paa,
1378: pay_payroll_actions ppa
1379: WHERE paa.assignment_action_id = c_assignment_action_id
1380: AND ppa.payroll_action_id = paa.payroll_action_id;
1381: --

Line 1521: FROM pay_assignment_actions paa,

1517: cursor last_start_date(c_assignment_action_id IN NUMBER)
1518: is
1519: SELECT /*+ ORDERED */
1520: trunc(ppa.effective_date,'YYYY')
1521: FROM pay_assignment_actions paa,
1522: pay_payroll_actions ppa
1523: WHERE paa.assignment_action_id = c_assignment_action_id
1524: AND ppa.payroll_action_id = paa.payroll_action_id;
1525: --

Line 1665: FROM pay_assignment_actions ASSACT,

1661: SELECT /*+ ORDERED */
1662: add_months(nvl(FND_DATE.CANONICAL_TO_DATE(HROG.org_information11),trunc(PACT.date_earned,'YYYY')),
1663: floor(months_between(PACT.date_earned,nvl(FND_DATE.CANONICAL_TO_DATE(HROG.org_information11),
1664: trunc(PACT.date_earned,'YYYY')))/12)*12) last_start_date
1665: FROM pay_assignment_actions ASSACT,
1666: pay_payroll_actions PACT,
1667: hr_organization_information HROG
1668: WHERE ASSACT.assignment_action_id = c_assignment_action_id
1669: AND PACT.payroll_action_id = ASSACT.payroll_action_id

Line 1679: FROM pay_assignment_actions ASSACT,

1675: is
1676: SELECT /*+ ORDERED */
1677: TO_NUMBER(substr(max(lpad(ASSACT.action_sequence,15,'0')||
1678: ASSACT.assignment_action_id),16))
1679: FROM pay_assignment_actions ASSACT,
1680: pay_payroll_actions PACT
1681: WHERE ASSACT.assignment_id = c_assignment_id
1682: AND PACT.payroll_action_id = ASSACT.payroll_action_id
1683: AND PACT.date_earned <= c_effective_date

Line 1836: FROM pay_assignment_actions ASSACT,

1832: SELECT /*+ ORDERED */
1833: add_months(nvl(FND_DATE.CANONICAL_TO_DATE(HROG.org_information11),trunc(PACT.effective_date,'YYYY')),
1834: floor(months_between(PACT.effective_date,nvl(FND_DATE.CANONICAL_TO_DATE(HROG.org_information11),
1835: trunc(PACT.effective_date,'YYYY')))/12)*12) last_start_date
1836: FROM pay_assignment_actions ASSACT,
1837: pay_payroll_actions PACT,
1838: hr_organization_information HROG
1839: WHERE ASSACT.assignment_action_id = c_assignment_action_id
1840: AND PACT.payroll_action_id = ASSACT.payroll_action_id

Line 1851: FROM pay_assignment_actions ASSACT,

1847: is
1848: SELECT /*+ ORDERED */
1849: TO_NUMBER(substr(max(lpad(ASSACT.action_sequence,15,'0')||
1850: ASSACT.assignment_action_id),16))
1851: FROM pay_assignment_actions ASSACT,
1852: pay_payroll_actions PACT
1853: WHERE ASSACT.assignment_id = c_assignment_id
1854: AND PACT.payroll_action_id = ASSACT.payroll_action_id
1855: AND PACT.effective_date <= c_effective_date

Line 1992: from pay_assignment_actions paa,

1988: cursor last_start_date(c_assignment_action_id in number)
1989: is
1990: select /*+ ORDERED */
1991: add_months(trunc(add_months(ppa.effective_date,9),'YYYY'),-9)
1992: from pay_assignment_actions paa,
1993: pay_payroll_actions ppa
1994: where paa.assignment_action_id = c_assignment_action_id
1995: and ppa.payroll_action_id = paa.payroll_action_id;
1996: --

Line 2141: FROM pay_assignment_actions paa,

2137: cursor last_start_date(c_assignment_action_id IN NUMBER)
2138: is
2139: SELECT /*+ ORDERED */
2140: add_months(trunc(add_months(ppa.effective_date,5),'YYYY'),-5)
2141: FROM pay_assignment_actions paa,
2142: pay_payroll_actions ppa
2143: WHERE paa.assignment_action_id = c_assignment_action_id
2144: AND ppa.payroll_action_id = paa.payroll_action_id;
2145: --

Line 2281: FROM pay_assignment_actions paa,

2277: cursor last_start_date(c_assignment_action_id IN NUMBER)
2278: is
2279: SELECT /*+ ORDERED */
2280: add_months(trunc(add_months(ppa.effective_date,6),'YYYY'),-6)
2281: FROM pay_assignment_actions paa,
2282: pay_payroll_actions ppa
2283: WHERE paa.assignment_action_id = c_assignment_action_id
2284: AND paa.payroll_action_id = ppa.payroll_action_id;
2285: --

Line 2547: FROM pay_assignment_actions paa,

2543: cursor expired_time_period(c_assignment_action_id IN NUMBER)
2544: is
2545: SELECT /*+ ORDERED */
2546: ptp.end_date
2547: FROM pay_assignment_actions paa,
2548: pay_payroll_actions ppa,
2549: per_time_periods ptp
2550: WHERE paa.assignment_action_id = c_assignment_action_id
2551: AND ppa.payroll_action_id = paa.payroll_action_id

Line 2693: FROM pay_assignment_actions paa,

2689: cursor expired_time_period(c_assignment_action_id IN NUMBER)
2690: is
2691: SELECT /*+ ORDERED */
2692: ptp.end_date
2693: FROM pay_assignment_actions paa,
2694: pay_payroll_actions ppa,
2695: per_time_periods ptp
2696: WHERE paa.assignment_action_id = c_assignment_action_id
2697: AND ppa.payroll_action_id = paa.payroll_action_id