APPS.PAY_JP_ISDF_SS_PKG dependencies on PAY_JP_ISDF_PACT_V

Line 49: pay_jp_isdf_pact_v pact

45: pact.submission_start_date,
46: pact.submission_end_date
47: from pay_jp_isdf_assact_v assact,
48: pay_assignment_actions paa,
49: pay_jp_isdf_pact_v pact
50: where assact.action_information_id = p_action_information_id
51: and paa.assignment_action_id = assact.assignment_action_id
52: and pact.payroll_action_id = paa.payroll_action_id;
53: --

Line 4898: from pay_jp_isdf_pact_v

4894: begin
4895: --
4896: select effective_date
4897: into l_effective_date
4898: from pay_jp_isdf_pact_v
4899: where payroll_action_id = p_payroll_action_id;
4900: --
4901: insert_session(l_effective_date);
4902: commit;

Line 4983: from pay_jp_isdf_pact_v

4979: begin
4980: --
4981: select effective_date
4982: into l_effective_date
4983: from pay_jp_isdf_pact_v
4984: where payroll_action_id = p_payroll_action_id;
4985: --
4986: insert_session(l_effective_date);
4987: commit;

Line 5070: from pay_jp_isdf_pact_v

5066: begin
5067: --
5068: select effective_date
5069: into l_effective_date
5070: from pay_jp_isdf_pact_v
5071: where payroll_action_id = p_payroll_action_id;
5072: --
5073: if p_transfer_date is not null then
5074: l_effective_date := fnd_date.canonical_to_date(p_transfer_date);

Line 5164: from pay_jp_isdf_pact_v

5160: begin
5161: --
5162: select effective_date
5163: into l_effective_date
5164: from pay_jp_isdf_pact_v
5165: where payroll_action_id = p_payroll_action_id;
5166: --
5167: if p_expiry_date is not null then
5168: l_effective_date := fnd_date.canonical_to_date(p_expiry_date);