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 907: FROM pay_payroll_actions PACT,

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

Line 918: FROM pay_payroll_actions ppa,

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

Line 1059: pay_payroll_actions ppa,

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

Line 1208: pay_payroll_actions ppa,

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

Line 1358: pay_payroll_actions ppa

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

Line 1502: pay_payroll_actions ppa

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

Line 1646: pay_payroll_actions PACT,

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

Line 1660: pay_payroll_actions PACT

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

Line 1817: pay_payroll_actions PACT,

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

Line 1832: pay_payroll_actions PACT

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

Line 1973: pay_payroll_actions ppa

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

Line 2122: pay_payroll_actions ppa

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

Line 2262: pay_payroll_actions ppa

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

Line 2528: pay_payroll_actions ppa,

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

Line 2674: pay_payroll_actions ppa,

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