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.PAY_JP_ISDF_SS_PKG dependencies on PAY_JP_ISDF_ASSACT_V

Line 52: from pay_jp_isdf_assact_v assact,

48: select /*+ ORDERED */
49: pact.submission_period_status,
50: pact.submission_start_date,
51: pact.submission_end_date
52: from pay_jp_isdf_assact_v assact,
53: pay_assignment_actions paa,
54: pay_jp_isdf_pact_v pact
55: where assact.action_information_id = p_action_information_id
56: and paa.assignment_action_id = assact.assignment_action_id

Line 190: from pay_jp_isdf_assact_v pjia,

186: select /* +ORDERED */
187: ppa.payroll_action_id,
188: ppa.business_group_id,
189: ppa.effective_date
190: from pay_jp_isdf_assact_v pjia,
191: pay_assignment_actions paa,
192: pay_payroll_actions ppa
193: where pjia.action_information_id = p_action_information_id
194: and paa.assignment_action_id = pjia.assignment_action_id

Line 1475: l_assact_rec pay_jp_isdf_assact_v%rowtype;

1471: is
1472: --
1473: l_proc varchar2(80) := c_package||'do_new';
1474: l_submission_date date;
1475: l_assact_rec pay_jp_isdf_assact_v%rowtype;
1476: l_payroll_action_id number;
1477: --
1478: cursor csr_pact
1479: is

Line 1599: l_assact_rec pay_jp_isdf_assact_v%rowtype;

1595: p_object_version_number in out nocopy number)
1596: is
1597: l_proc varchar2(80) := c_package||'do_apply';
1598: l_submission_date date;
1599: l_assact_rec pay_jp_isdf_assact_v%rowtype;
1600: begin
1601: --
1602: if g_debug then
1603: hr_utility.set_location(l_proc,0);

Line 3082: l_assact_rec pay_jp_isdf_assact_v%rowtype;

3078: is
3079: --
3080: l_proc varchar2(80) := c_package||'do_calculate';
3081: l_submission_date date;
3082: l_assact_rec pay_jp_isdf_assact_v%rowtype;
3083: l_calc_dct_rec t_calc_dct_rec;
3084: l_action_information_id number;
3085: l_object_version_number number;
3086: --

Line 3124: from pay_jp_isdf_assact_v

3120: --
3121: -- unnecessary to lock
3122: select *
3123: into l_assact_rec
3124: from pay_jp_isdf_assact_v
3125: where action_information_id = p_action_information_id;
3126: --
3127: if l_assact_rec.transaction_status <> 'N' then
3128: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');

Line 3291: l_assact_rec pay_jp_isdf_assact_v%rowtype;

3287: is
3288: --
3289: l_proc varchar2(80) := c_package||'do_finalize';
3290: l_submission_date date;
3291: l_assact_rec pay_jp_isdf_assact_v%rowtype;
3292: l_calc_dct_rec t_calc_dct_rec;
3293: l_action_information_id number;
3294: l_object_version_number number;
3295: --

Line 3668: l_assact_rec pay_jp_isdf_assact_v%rowtype;

3664: is
3665: --
3666: l_proc varchar2(80) := c_package||'do_finalize';
3667: l_submission_date date;
3668: l_assact_rec pay_jp_isdf_assact_v%rowtype;
3669: --
3670: begin
3671: --
3672: if g_debug then

Line 3755: l_assact_rec pay_jp_isdf_assact_v%rowtype;

3751: is
3752: --
3753: l_proc varchar2(80) := c_package||'do_return';
3754: l_submission_date date;
3755: l_assact_rec pay_jp_isdf_assact_v%rowtype;
3756: --
3757: begin
3758: --
3759: if g_debug then

Line 3834: l_assact_rec pay_jp_isdf_assact_v%rowtype;

3830: p_object_version_number in out nocopy number)
3831: is
3832: --
3833: l_proc varchar2(80) := c_package||'do_approve';
3834: l_assact_rec pay_jp_isdf_assact_v%rowtype;
3835: --
3836: begin
3837: --
3838: if g_debug then

Line 5269: l_assact_rec pay_jp_isdf_assact_v%rowtype;

5265: p_expire_after_transfer in varchar2 default 'N')
5266: is
5267: --
5268: l_proc varchar2(80) := c_package||'do_transfer';
5269: l_assact_rec pay_jp_isdf_assact_v%rowtype;
5270: l_effective_date date;
5271: l_year_end_date date;
5272: l_dec_first_date date;
5273: --

Line 5570: l_assact_rec pay_jp_isdf_assact_v%rowtype;

5566: -- ZAP : remove archive data of status D
5567: -- N/A : nothing to do. (original)
5568: --
5569: l_proc varchar2(80) := c_package||'do_expire';
5570: l_assact_rec pay_jp_isdf_assact_v%rowtype;
5571: l_effective_date date;
5572: l_dec_first_date date;
5573: l_year_end_date date;
5574: l_esd date;

Line 5804: pay_jp_isdf_assact_v assact,

5800: assact.object_version_number,
5801: pp.full_name,
5802: pa.assignment_number
5803: from pay_assignment_actions paa,
5804: pay_jp_isdf_assact_v assact,
5805: per_all_assignments_f pa,
5806: per_all_people_f pp
5807: where paa.payroll_action_id = p_payroll_action_id
5808: and paa.action_status = 'C'

Line 5889: pay_jp_isdf_assact_v assact,

5885: assact.object_version_number,
5886: pp.full_name,
5887: pa.assignment_number
5888: from pay_assignment_actions paa,
5889: pay_jp_isdf_assact_v assact,
5890: per_all_assignments_f pa,
5891: per_all_people_f pp
5892: where paa.payroll_action_id = p_payroll_action_id
5893: and paa.action_status = 'C'

Line 5975: pay_jp_isdf_assact_v assact,

5971: assact.object_version_number,
5972: pp.full_name,
5973: pa.assignment_number
5974: from pay_assignment_actions paa,
5975: pay_jp_isdf_assact_v assact,
5976: per_all_assignments_f pa,
5977: per_all_people_f pp
5978: where paa.payroll_action_id = p_payroll_action_id
5979: and paa.action_status = 'C'

Line 6069: pay_jp_isdf_assact_v assact,

6065: assact.object_version_number,
6066: pp.full_name,
6067: pa.assignment_number
6068: from pay_assignment_actions paa,
6069: pay_jp_isdf_assact_v assact,
6070: per_all_assignments_f pa,
6071: per_all_people_f pp
6072: where paa.payroll_action_id = p_payroll_action_id
6073: and paa.action_status = 'C'