APPS.PAY_JP_ISDF_SS_PKG dependencies on PAY_JP_ISDF_PACT_V

Line 54: pay_jp_isdf_pact_v pact

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
57: and pact.payroll_action_id = paa.payroll_action_id;
58: --

Line 5824: from pay_jp_isdf_pact_v

5820: begin
5821: --
5822: select effective_date
5823: into l_effective_date
5824: from pay_jp_isdf_pact_v
5825: where payroll_action_id = p_payroll_action_id;
5826: --
5827: insert_session(l_effective_date);
5828: commit;

Line 5909: from pay_jp_isdf_pact_v

5905: begin
5906: --
5907: select effective_date
5908: into l_effective_date
5909: from pay_jp_isdf_pact_v
5910: where payroll_action_id = p_payroll_action_id;
5911: --
5912: insert_session(l_effective_date);
5913: commit;

Line 5996: from pay_jp_isdf_pact_v

5992: begin
5993: --
5994: select effective_date
5995: into l_effective_date
5996: from pay_jp_isdf_pact_v
5997: where payroll_action_id = p_payroll_action_id;
5998: --
5999: if p_transfer_date is not null then
6000: l_effective_date := fnd_date.canonical_to_date(p_transfer_date);

Line 6090: from pay_jp_isdf_pact_v

6086: begin
6087: --
6088: select effective_date
6089: into l_effective_date
6090: from pay_jp_isdf_pact_v
6091: where payroll_action_id = p_payroll_action_id;
6092: --
6093: if p_expiry_date is not null then
6094: l_effective_date := fnd_date.canonical_to_date(p_expiry_date);