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_PAYROLL_ACTIONS

Line 86: from pay_payroll_actions ppa_owner,

82: ppa_owner.date_earned
83: into l_business_group_id,
84: l_user_date_earned,
85: l_owner_date_earned
86: from pay_payroll_actions ppa_owner,
87: pay_payroll_actions ppa_user
88: where ppa_user.payroll_action_id = p_user_payroll_action_id
89: and ppa_owner.payroll_action_id = p_owner_payroll_action_id;
90: --

Line 87: pay_payroll_actions ppa_user

83: into l_business_group_id,
84: l_user_date_earned,
85: l_owner_date_earned
86: from pay_payroll_actions ppa_owner,
87: pay_payroll_actions ppa_user
88: where ppa_user.payroll_action_id = p_user_payroll_action_id
89: and ppa_owner.payroll_action_id = p_owner_payroll_action_id;
90: --
91: IF p_dimension_name = hr_jprts.g_asg_fytd_jp THEN

Line 143: FROM pay_payroll_actions OWNER

139: --
140: cursor csr_business_group is
141: SELECT OWNER.business_group_id,
142: OWNER.date_earned
143: FROM pay_payroll_actions OWNER
144: WHERE OWNER.payroll_action_id = p_owner_payroll_action_id;
145: BEGIN
146: -- To solve gscc error
147: l_proc := c_package || 'check_expiry';

Line 271: pay_payroll_actions ppa

267: --
268: select pbf.scale
269: into p_feed_scale
270: from pay_balance_feeds_f pbf,
271: pay_payroll_actions ppa
272: where ppa.payroll_action_id = p_payroll_action_id
273: and pbf.balance_type_id = p_bt_id
274: and pbf.input_value_id = p_iv_id
275: and ppa.date_earned

Line 392: pay_payroll_actions ppa

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');
396: --

Line 428: pay_payroll_actions ppa

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
432: AND ppa.action_type in ('R', 'Q', 'I', 'V', 'B');

Line 463: l_action_type pay_payroll_actions.action_type%TYPE;

459: l_date_earned DATE ;
460: l_from_date DATE;
461: l_to_date DATE;
462: l_action_sequence NUMBER;
463: l_action_type pay_payroll_actions.action_type%TYPE;
464: l_business_group_id NUMBER;
465: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
466: l_dimension_jp_type VARCHAR2(15);
467: l_latest_value_exists VARCHAR(2);

Line 477: FROM pay_payroll_actions BACT,

473: BACT.action_type,
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: --

Line 624: pay_payroll_actions ppa,

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,
628: pay_defined_balances pdb

Line 927: FROM pay_payroll_actions PACT,

923: c_effective_date IN DATE)
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

Line 938: FROM pay_payroll_actions ppa,

934: cursor last_date (c_assignment_action_id IN NUMBER)
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: --

Line 1079: pay_payroll_actions ppa,

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
1083: AND ptp.time_period_id = ppa.time_period_id;

Line 1228: pay_payroll_actions ppa,

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
1232: AND ptp.time_period_id = ppa.time_period_id;

Line 1378: pay_payroll_actions ppa

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: --
1382: BEGIN

Line 1522: pay_payroll_actions ppa

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: --
1526: BEGIN

Line 1666: pay_payroll_actions PACT,

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
1670: AND HROG.organization_id = PACT.business_group_id

Line 1680: pay_payroll_actions PACT

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
1684: AND PACT.action_type in ('R', 'Q', 'I', 'V', 'B');

Line 1837: pay_payroll_actions PACT,

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
1841: AND HROG.organization_id = PACT.business_group_id

Line 1852: pay_payroll_actions PACT

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
1856: AND PACT.action_type in ('R', 'Q', 'I', 'V', 'B');

Line 1993: pay_payroll_actions ppa

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: --
1997: begin

Line 2142: pay_payroll_actions ppa

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: --
2146: BEGIN

Line 2282: pay_payroll_actions ppa

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: --
2286: BEGIN

Line 2548: pay_payroll_actions ppa,

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
2552: AND ptp.time_period_id = ppa.time_period_id;

Line 2694: pay_payroll_actions ppa,

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
2698: AND ptp.time_period_id = ppa.time_period_id;