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_DYNSQL dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 915: from hr_assignment_set_amendments amd

911: into dummy
912: from sys.dual
913: where exists (
914: select null
915: from hr_assignment_set_amendments amd
916: where amd.assignment_set_id = asetid
917: and amd.include_or_exclude = 'I');
918: exception
919: when no_data_found then include := FALSE;

Line 931: from hr_assignment_set_amendments amd

927: into dummy
928: from sys.dual
929: where exists (
930: select null
931: from hr_assignment_set_amendments amd
932: where amd.assignment_set_id = asetid
933: and amd.include_or_exclude = 'E');
934: exception
935: when no_data_found then exclude := FALSE;

Line 1330: hr_assignment_set_amendments amd,

1326: select '|| case chkno when null then '' else l_hints end ||' act.assignment_id,
1327: act.assignment_action_id
1328: from pay_payroll_actions pac,
1329: pay_population_ranges pop,
1330: hr_assignment_set_amendments amd,
1331: per_all_assignments_f pay_asg,
1332: pay_assignment_actions act
1333: where pac.payroll_action_id = :pactid
1334: and act.payroll_action_id = pac.payroll_action_id

Line 1356: from hr_assignment_set_amendments exc

1352: if(exclude) then
1353: sqlstr := sqlstr || '
1354: and not exists (
1355: select null
1356: from hr_assignment_set_amendments exc
1357: where exc.assignment_set_id = has.assignment_set_id
1358: and exc.include_or_exclude = ''E''
1359: and act.assignment_id = exc.assignment_id)';
1360: end if;

Line 1421: hr_assignment_set_amendments amd

1417: sqlstr := '
1418: select pay_asg.assignment_id
1419: from per_all_assignments_f pay_asg,
1420: hr_assignment_sets has,
1421: hr_assignment_set_amendments amd
1422: where has.assignment_set_id = :asetid
1423: and amd.assignment_set_id = has.assignment_set_id
1424: and pay_asg.payroll_id + 0 = has.payroll_id
1425: and pay_asg.assignment_id = amd.assignment_id

Line 1442: from hr_assignment_set_amendments amd

1438: and fnd_date.canonical_to_date(:v_effective_date) between
1439: pay_asg.effective_start_date and pay_asg.effective_end_date
1440: and not exists (
1441: select null
1442: from hr_assignment_set_amendments amd
1443: where amd.assignment_set_id = has.assignment_set_id
1444: and pay_asg.assignment_id = amd.assignment_id
1445: and amd.include_or_exclude = ''E'')';
1446: end if;

Line 1564: hr_assignment_set_amendments amd,

1560: select pay_asg.assignment_id, pay_asg.assignment_number,
1561: pay_asg.payroll_id, pesm.element_type_id, petf.element_name
1562: from per_all_assignments_f pay_asg,
1563: hr_assignment_sets has,
1564: hr_assignment_set_amendments amd,
1565: PAY_ELEMENT_SET_MEMBERS pesm,
1566: pay_element_types_f petf
1567: where pay_asg.business_group_id = :p_bgid
1568: and has.assignment_set_id = :pasetid

Line 1601: hr_assignment_set_amendments amd,

1597: select pay_asg.assignment_id, pay_asg.assignment_number,
1598: pay_asg.payroll_id,petf.element_type_id, petf.element_name
1599: from per_all_assignments_f pay_asg,
1600: hr_assignment_sets has,
1601: hr_assignment_set_amendments amd,
1602: pay_element_types_f petf
1603: where pay_asg.business_group_id = :p_bgid
1604: and has.assignment_set_id = :pasetid
1605: and amd.assignment_set_id = has.assignment_set_id

Line 1635: from hr_assignment_set_amendments amd

1631: and fnd_date.canonical_to_date(:p_effective_date) between
1632: pay_asg.effective_start_date and pay_asg.effective_end_date
1633: and not exists (
1634: select null
1635: from hr_assignment_set_amendments amd
1636: where amd.assignment_set_id = has.assignment_set_id
1637: and pay_asg.assignment_id = amd.assignment_id
1638: and amd.include_or_exclude = ''E'')
1639: and pesm.element_set_id = :p_elesetid

Line 1677: from hr_assignment_set_amendments amd

1673: and fnd_date.canonical_to_date(:p_effective_date) between
1674: pay_asg.effective_start_date and pay_asg.effective_end_date
1675: and not exists (
1676: select null
1677: from hr_assignment_set_amendments amd
1678: where amd.assignment_set_id = has.assignment_set_id
1679: and pay_asg.assignment_id = amd.assignment_id
1680: and amd.include_or_exclude = ''E'')';
1681: --

Line 1800: hr_assignment_set_amendments amd,

1796: select pay_asg.assignment_id,
1797: pay_asg.payroll_id
1798: from per_all_assignments_f pay_asg,
1799: hr_assignment_sets has,
1800: hr_assignment_set_amendments amd,
1801: per_quickpaint_invocations inv
1802: where inv.qp_invocation_id = :qp_invocation_id
1803: and has.assignment_set_id = inv.invocation_context
1804: and amd.assignment_set_id = has.assignment_set_id

Line 1821: from hr_assignment_set_amendments amd

1817: if(exclude) then
1818: sqlstr := sqlstr || '
1819: and not exists (
1820: select null
1821: from hr_assignment_set_amendments amd
1822: where amd.assignment_set_id = has.assignment_set_id
1823: and amd.include_or_exclude = ''E''
1824: and pay_asg.assignment_id = amd.assignment_id)';
1825: end if;

Line 2239: l_inc_or_excl HR_ASSIGNMENT_SET_AMENDMENTS.INCLUDE_OR_EXCLUDE%TYPE;

2235: PYG_AT_REV constant varchar2(1) := 'V'; -- Reversal
2236:
2237: l_ret_timedepflg varchar2(1);
2238: l_asg_set_id number;
2239: l_inc_or_excl HR_ASSIGNMENT_SET_AMENDMENTS.INCLUDE_OR_EXCLUDE%TYPE;
2240: begin
2241: --
2242: pay_proc_logging.PY_ENTRY('hr_dynsql.pyrsql');
2243: --

Line 2586: from hr_assignment_set_amendments

2582: -- Find out if an include or exclude assignment set
2583: --
2584: select include_or_exclude
2585: into l_inc_or_excl
2586: from hr_assignment_set_amendments
2587: where assignment_set_id = l_asg_set_id
2588: and rownum = 1;
2589: EXCEPTION
2590: When OTHERS Then

Line 3126: hr_assignment_set_amendments pay_inc

3122: adeincspc := '
3123: from per_periods_of_service pay_pos,
3124: per_all_assignments_f pay_asg,
3125: pay_payroll_actions pay_pac,
3126: hr_assignment_set_amendments pay_inc
3127: where pay_pac.payroll_action_id = :pactid
3128: and pay_asg.payroll_id = pay_pac.payroll_id
3129: and pay_inc.assignment_set_id = pay_pac.assignment_set_id + decode(pay_pos.period_of_service_id, null, 0, 0)
3130: and pay_inc.assignment_id = pay_asg.assignment_id + decode(pay_pos.period_of_service_id, null, 0, 0)

Line 3173: hr_assignment_set_amendments pay_inc,

3169: rspcinc := '
3170: from per_periods_of_service pay_pos,
3171: per_all_assignments_f pay_asg,
3172: per_all_assignments_f pay_as2,
3173: hr_assignment_set_amendments pay_inc,
3174: pay_payroll_actions pay_pac
3175: where pay_pac.payroll_action_id = :payroll_action_id
3176: and pay_pac.assignment_set_id = pay_inc.assignment_set_id
3177: and pay_asg.assignment_id = pay_inc.assignment_id

Line 3195: hr_assignment_set_amendments pay_inc,

3191: spcinc := '
3192: from per_periods_of_service pay_pos,
3193: per_all_assignments_f pay_asg,
3194: per_all_assignments_f pay_as2,
3195: hr_assignment_set_amendments pay_inc,
3196: pay_payroll_actions pay_pac
3197: where pay_pac.payroll_action_id = :payroll_action_id
3198: and pay_inc.assignment_set_id = pay_pac.assignment_set_id
3199: and pay_inc.assignment_id = pay_asg.assignment_id

Line 3214: hr_assignment_set_amendments pay_inc,

3210: revspcinc := '
3211: from per_periods_of_service pay_pos,
3212: per_all_assignments_f pay_asg,
3213: per_all_assignments_f pay_as2,
3214: hr_assignment_set_amendments pay_inc,
3215: pay_payroll_actions pay_pac,
3216: pay_assignment_actions pay_paa2,
3217: pay_payroll_actions pay_pac2
3218: where pay_pac.payroll_action_id = :payroll_action_id

Line 3240: hr_assignment_set_amendments pay_inc,

3236: -- Purge Specific inclusions.
3237: purspcinc := '
3238: from per_periods_of_service pay_pos,
3239: per_all_assignments_f pay_asg,
3240: hr_assignment_set_amendments pay_inc,
3241: pay_payroll_actions pay_pac
3242: where pay_pac.payroll_action_id = :payroll_action_id
3243: and pay_inc.assignment_set_id = pay_pac.assignment_set_id
3244: and pay_inc.assignment_id = pay_asg.assignment_id

Line 3254: hr_assignment_set_amendments pay_inc,

3250: -- Retropay inclusions
3251: spcretinc := '
3252: from per_periods_of_service pay_pos,
3253: per_all_assignments_f pay_asg,
3254: hr_assignment_set_amendments pay_inc,
3255: pay_payroll_actions pay_pac
3256: where pay_pac.payroll_action_id = :payroll_action_id
3257: and pay_inc.assignment_set_id = pay_pac.assignment_set_id + decode(pay_pos.period_of_service_id, null, 0, 0)
3258: and pay_inc.assignment_id = pay_asg.assignment_id + decode(pay_pos.period_of_service_id, null, 0, 0)

Line 3268: hr_assignment_set_amendments pay_inc,

3264: --
3265: -- RetroCosting inclusions
3266: spcrcsinc := '
3267: from per_periods_of_service pay_pos,
3268: hr_assignment_set_amendments pay_inc,
3269: per_all_assignments_f pay_asg,
3270: per_all_assignments_f pay_as2,
3271: pay_payroll_actions pay_pac
3272: where pay_pac.payroll_action_id = :pactid

Line 3459: from hr_assignment_set_amendments pay_exc

3455: -- not exists to exclude specific assignments.
3456: excspc := '
3457: and not exists (
3458: select null
3459: from hr_assignment_set_amendments pay_exc
3460: where pay_exc.assignment_set_id = pay_pac.assignment_set_id
3461: and pay_exc.assignment_id = pay_asg.assignment_id
3462: and pay_exc.include_or_exclude = ''E'')';
3463: --